Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |