Comparing with previous selected time period in DAX

This video describes how you can create a comparison with the previous time period in a visualization, regardless of whether the time periods are consecutive or not.
Article and download: sql.bi/526183/...
How to learn DAX: www.sqlbi.com/...
The definitive guide to DAX: www.sqlbi.com/...

[@SumanMondal-d2y]

Every week a learn a new thing from this KZbin channel .Thanks a lot . This really helped me in my ongoing project .Sundays well invested

[@AlexanderCortes210486]

What a great explanation Mr. Ferrari, thanks for sharing your amazing knowledge with the community...!

[@mudassarhussain5424]

After a whole week in finding a solution. your this video makes my work way easy. i was working on price elasticity project. as some products did not sell daily so date gap created problem to use offset to get previous date data to check change in value. I really appreciate.

[@flikg]

Alberto I wish you were my professor during studies!!!!! THANK YOU SO MUCH FOR THE WORK YOU ARE DOING!!!

[@adityaupadhyay3242]

Wow this is such a smooth and clean explanation. KeepFilters is a blessing.

[@passioncreativekass-sand827]

TROP TOP, je cherchais depuis 10 jours et j'allais abandonner. Merci infiniment. J'ai encore appris quelque chose.De plus la traduction ene français me permet de comprendre sans bêtement reproduire MERCI MERCI

[@manassehkisame6286]

This tutorial is Golden. I have mined and mined for days on end till this Eureka Moment @ SQLBI!

[@VladMZ]

Precious! This is exactly what I need. I have a task where Output of one stage this week is an Input for the subsequent stage next week. I already created a column with week number relative to the current week (negative in past, 0 current, positive in future), so I'll just use it for this calculation. Thank you!

[@amarnadhgunakala2901]

Everyday one new thing that makes my learning keep on going, Thanks Alberto

[@olivergruss6018]

Great Work as always - im very glad you started a youtube Channel. I hope you become the msot popular PowerBi Channel. Nobody else is more than an expert on the topic than you guys. Keep up the good work. It will pay off :)

[@Phongtrung02]

This video literally saves me from my job fired, thanks alot

[@nazirakhan6530]

Thanks Alberto !! Everytime you make us learn something new and exciting

[@huseyinburaktasci]

Amazing! This is a code I was searching for some time. Thank you! I follow you with admiration. Regards.

[@brockyoutube]

Genius, I was able to use your code as a base to what I really needed. Thanks for posting!

[@salvatorescofano6756]

Alberto, congratulation, This video is very strong, but you transform in easy.!!

[@DanielADamico]

It seems easy when it's explained by you guys! Thanks for sharing!

[@ShabnamKhan-vk7fj]

This is amazing. Thanks for making DAX so enjoyable for us.

[@satishkumardommeti8282]

Alberto, you make DAX sound very simple. In fact, when I get to my keyboard to write the measure, I mostly end up missing some step. Maybe, I need more practice for sure. Cheers!!!

[@sushiheartt]

thanks a lot for sharing this. may i know how to compute the growth/variance for this case for selected months too?

[@ekaterinamoskvina2067]

Just amasing! THANKS A LOT!!!

[@mnowako]

Thank you, professor Alberto!

[@pawewrona9749]

Thank you for another great video!

[@Bharath_PBI]

Thanks again for another video. 👍

[@mohamedfasil4891]

Great Video ! Its Really helpful for me and I have one question That is In second page your slicer is Year Month Name not Year Month Number . I want to know how to do that instead month number we have to put month name in dax ?

[@1yyymmmddd]

Great, as always. Thanks !

[@k.b.jayakumar5136]

Excellent Video, Thank you Sir.

[@Vitor-hb8dt]

AMAZING! It helped me a lot!!!

[@kebincui]

Thanks Alberto 👍👍👍

[@athandapani]

Very good example 👍

[@aliceqiuyingtan7222]

Thanks for sharing, this is really useful and amazing. I just have a question, if in my report, i have several slicers. How can i modifiy the mesure? the target is the comparaison calculates with these choices of slicers

[@kkelinaa]

Thank you for useful informations.

[@namithamukundan]

Hi Thank you for the video. I am trying to get a variance for two different time period and the time period is selected basis the end user. Like in the video. Do advise on the same.

[@Minifini4]

This measure doesn’t show in “Total” in the table. Is there a way to have sub/total as well? Many thanks

[@mohammed333suliman]

Thank you Alberto

[@andrea31050]

It works great on a table, but i have problems when i add the measure as a value in a matrix. I'm trying to compare the selected week with it's previous week. as selecting week 10, and showing two columns with sales form week 9 and 10

[@unitedwings7644]

Hey hi in powerbi I want to compare a value for continuous 15 mins if the value is same for 15mins continuously and I need a count 1 for that

[@pradeeprawatvlogs8358]

sir i have a problem which i wanted to slove that is i wanted to compare between different periods like last 7 days, 14, 30 & Month to date with previous month to date but all these option should be on slicer and the all visuals which resides in the page should reflect the output please suggest me how to do i have tried but i am unable to do it.

[@ravi__negi__4333]

Ahh amazing plesse bring some real workd scerio problem in DAX...😊

[@SQLBI]

Look at www.daxpatterns.com

[@sbn4862]

Hi Mr Alberto I can't sort my Year Month in another my table, No YearNumber and YearMonthNumber can help.

[@colin8601]

This was amazing ! I've used this in my retail 4-5-4 data model but I'm very confused on what I need to change in the previous month formula. When I don't use any filters on my output, it works beautifully! The second I try and filter anything on the visual, it returns in accurate data . I know it has something to do with filter context Inside but I can't understand. Can you or anyone help?

[@SQLBI]

For 4-5-4 look at the formulas here: www.daxpatterns.com/week-related-calculations/

[@l3ol3lca]

Thank You!

[@felipesignorellireis7839]

Very good. Thanks

[@douglasgimenez7852]

Muito bom conteudo!!!

[@Knud451]

Thanks. Sorry for posting the question here. Is it possible to make the names of measures dynamic? If so, can you do a video on it? It would really help in visualising/explaining some reports I have.

[@SQLBI]

No, measure and column names are defined in the model and cannot change. You can dynamically change the title of a visual in a report, though.

[@Knud451]

@@SQLBI thanks. The thing is that I have several measures in the visual and they all need to change independently of each other.

[@pravinupadhyay2046]

Very good, i was thinking if we have suppose products or brands in the place of month year ???

[@SQLBI]

Potentially you could use a similar approach - but in which case you compare a product with the previous product? And you don't have the notion of "periods" there.

[@pravinupadhyay2046]

@@SQLBI thankyou for your response, I got your point, if products are ranked then I can use that rank as a notion for selected previous product.

[@Alan.DL7]

This is great. I have a measure that computes the same thing but after creating like 4 different measures to feed the final one... Now, my question is and I can't figure it out on my own sadly: how to use this measure but to display data for example by Product Category without having to add a date column in the matrix. Even if I keep the date column, as soon as I drill down to Product Category level, the measure shows only blanks. Any tips here, please?

[@SQLBI]

Try to reproduce the issue using the sample file you can download from the SQLBI website in the related article, and write your question in the comments to the article, it's easier to reply that way.

[@Alan.DL7]

@@SQLBI will definitely do that, thanks! I have also purchased the Mastering DAX course. Maybe my answer will be there too :)

[@akki4718]

in case if there is total we have to show based on selection then?

[@Usuario-gk1ni]

thanks!!!

[@salvatorescofano6756]

Do you have any video explain On-premises data gateway ? instalation and configuration from a SQL Server? tks best regards

[@SQLBI]

We only cover DAX and data modeling - you should look at guyinacube.com/2018/01/10/premises-data-gateway-power-bi-revisited/

[@welcometomathy]

Does it work between years?like dez21 Vs Jan22

[@Ladiesman7790]

Do you using a heatmap instead?

[@LuisGonzalez-uv2ti]

Let's say you want to compare 2023 YTD vs 2019 YTD, how would you do that?

[@picious]

made it!!! 1 View - on time :) ... thank you!!

[@3danim8r1]

Genius...

[@kalinduSekara]

Nice