% change depending on date drill down

[satubuku83]

Hi all,

Do you have any easy way to show % of change of certain value based on drill down of date (by year, quarter, month).

I have seen solution online of only specific date category (for example only month or yearly change, using DAX PREVIOUSMONTH, etc)

But my question is if there is any solution that caters for any date category drilldown?

Regards

[Floriankx · Accepted solution]

Hello,

yes it is possible.

If you have a contigous DateTable containing, Date, Year, Quarter, Month you can do so.

You could add a timeline and check with nested HASONEVALUE wether a full year, a quarter or only one month is selected.

Depending on selection you could use DATEADD,-1,[year/quarter/month] to get your PreviousPeriod Value to create your %ofChange.

Check here

[satubuku83]

Thanks for the solution,@Floriankx. Really appreciate!