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.
I've been having difficulty trying to create a measure correctly to display percentage change to add onto a line and bar chart.
I would like it to act similar to a Year over Year % but need the current Years YTD Average compared to each prior years full calendar year Average
My created measure is [Average] which is calculated by dividing [Product Revenue] and [Products Sold]
And my date calendar is just [Calendar] which the dates are always first of month (e.g. 4/1/2023)
Hi @Anonymous on link below check part "Year-over-year-to-date growth" (and other parts relating to your measures)
https://www.daxpatterns.com/standard-time-related-calculations/
I hope this help
Proud to be a Super User!
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 |
---|---|
107 | |
98 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |