How to Compare Different Time Periods or Date Ranges in Power BI or SSAS

In this video, we are going to see an effective way to compare or filter different time periods or date ranges. It is a useful technique to compare the value of a measure in different time periods.

We will use CALCULATE, USERELATIONSHIP and REMOVEFILTERS dax functions.

Watch our other video on time intelligence in Power BI:

Watch our introductory video on Power BI:

[luisafernandarojas]

You've saved me! This is by far the best video, you make me cry for happiness. Thank you, thank you!

[anthonydzikiewicz]

Very well done. I was looking for this. I also wanted to show the difference and percent change. This is a good start

[girijadhawale]

Very well explained. This is really helpful! Thank you so much :)

[bentatlim]

I love you ❤❤❤ Im looking for that since days. And you explain it soooo clear and smooth - THANK YOUUUU 🙏🏽🙏🏽🙏🏽

[sanyuktasuma]

This is exactly what I was looking for. Thanks!

[jaimerrojasrojas]

Thanks to share!!!. I'll include this in one of mi report, good idea.

[dppbixp]

Hi, Thank u for the great video. I have one doubt, I have created a live dash board that compares the values in two periods. Is there a way to show the default selected dates as last 30 days in both the slicer?

[andreabrunello]

Hello! Thank you for the super cool video.
One question: if you wanna display that in a bar chart with month in the X axis, how would you do it? I have a report similar to yours and used the corrispondent month field in "calendar" table. For the comparison value however doesnt react to that and displays same value in all the month columns...

[SmackDog]

I have an attribute column and a value column that I'm charting on a line graph. I would like to be able to compare line graphs of a selected attribute for different time periods. I can't visualize how to do this using this method since I'm not calculating a sum or average. Ideally I'd ignore the year on the graph so the two lines chart over the same months for easier comparison. Any thoughts?

[tabularasa]

how to put "month" in rows for both measures? they are stored in both calendars. thx for video

[dhaniamamodaly]

Hello, thank you for this video. Is it possible to show the selected dates in the column headers ?

[michaelcorsibin]

What if I want to show the nb cases for two different years in the visual and then show the difference. So when someone see the report they also want to know what cases were there in 2019 and 2017 rather than seeing only dates data !! Is there any possibility to show the data for both years and the comparison. It would be better if I can show these three as seperate visuals

[AryanGupta-ts]

If i have to compare the data only for all January's across all years and all february's across all years and so on, which video should i refer to?

[luisglz]

Super clear, thank you for the advice. Maybe you could have skipped the theming at the end :)

[luisa.rojas.]

Hi there, I have a doubt. If I want to compare many graphs, Do I have to create one calendar for each?