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.
How would you calculate the % change over the same months from this year to last year?
For example, I would like to calculate the % change from January to April of this year to January to April of last year?
I can't do YTD calculation or calculate using Quarters....any suggestions?
Please assume the date field is called ProjDate.
Thanks!
Solved! Go to Solution.
I assume you have a total sales measure
Try this
Total Sales Last Year = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR(YourDateTable[ProjDate]))
Diff This Year - Last Year = IF(ISBLANK([Total Sales Last Year]), BLANK(),[Total Sales] - [Total Sales Last Year])
% Diff = DIVIDE ([Diff This Year - Last Year],[Total Sales Last Year])
Also watch this video https://www.youtube.com/watch?v=JNt-_QByeLk
I assume you have a total sales measure
Try this
Total Sales Last Year = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR(YourDateTable[ProjDate]))
Diff This Year - Last Year = IF(ISBLANK([Total Sales Last Year]), BLANK(),[Total Sales] - [Total Sales Last Year])
% Diff = DIVIDE ([Diff This Year - Last Year],[Total Sales Last Year])
Also watch this video https://www.youtube.com/watch?v=JNt-_QByeLk
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |