DAX Fridays #214: Create DAX calculations on ranges taken from a slicer!!

In today's video, I will show you how you can grab the values selected on a slicer and use them as a range to make calculations, for example:
1. Sales variance between multiple years
2. Rank across multiple years
and many more!

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10
Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[rajeshvarre]

Thanks for all the videos teacher. You helped to fetch a job. Thanks curbal. Will pray for your happiness.

[dan]

You make it look so easy. Everytime I watch your videos I say to myself, "yup yup, makes sense...very easy, no prob"... And then I go to do something similar and it takes me an hour of googling to figure it out 😂

[MrAszpic]

Nice one! VERY useful for datasets with many years and wanting to compare 2 random ones, and without dummy rables or what-if parameters!

[ivancordova]

Muchas gracias por este gran contenido. Saludos desde Perú..

[marcobaquero]

So nice chart Ruth. Tks for sharing!!!!

[learntech]

Nice video...I have a question though, how can we change the column name dynamically, as in min sales slicer to 1996 and max sales slicer to 1998.
Is there a way to do that?

[umangdbz]

Why do we need Allselected and calculate?
Can't we simply use a variable for mac and min dates since slicer will modify the filter context anyway.

[sumit-visatotravel]

Helpfull. Just 1 question how did you make the measure definition window zoom in?

[gayatrilshinde]

I need your help,
How to give three condition in power bi ?
1.if month is selected in slicer then calculate MTD
2.if nothing is selected show the current month MTD
3.if multiple month selected in slicer then calculate selected month MTD
if you can help really important,
Thanks ❤️

[amirthaparthasarathy]

when i tried this im getting max(calendar['year']) as the final value, not what i sliced in the slicer

[abbielmi]

Nice video. Where i can download the data used for this video?

[davidmendez]

Hi Consuelo, I couldn't find your beautiful pbix in the download center. Could you confirm where it is please?

[marcor]

I would like that to be possible to include var into measure label 😢 like into Qlik… how can we push Microsoft to make some implementations? 😂

[vasudevpatil]

I am facing one challenge where I wanted to show the Current month value than Previous month value and then % change between these for multiple categorical variables, in columns in Table/Matrix visualization.
I could get the last 2 months values using measure but then when I tried to get the % change in visual, it appeared for both of the months side by side and not after the 2 columns.
I Want to create visuals like below
e.g.
Fund Category||Fund
Next month it would automatically change to
Fund Category||Fund

[biswajitjena]

Excel, Part time online job or website name for excel job, now I am jobless from 5 months..

[jaimemolina]

I don't understand why your measures are referencing the year 1997 but returning the sales for 2017.