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,
I want to create a chart which shows the cumulative sales of an order table with the month on the axis and my year on the legend.
Currently, I have the following formula to calculate the cumulative
Cumulative sales = CALCULATE(SUM(orders[Sales Value]);FILTER(ALL('Date');'Date'[Date] <= MAX('Date'[Date])))
But when I create the visual. I get this:
So it should reset every year but instead continues to count.
Any help?
Solved! Go to Solution.
Hi muren,
Modify your measure using DAX below and check if the issue can be resolved:
Cumulative sales = TOTALYTD ( SUM ( orders[Sales Value] ), Date[Date] )
Regards,
Jimmy Tao
Hi muren,
Modify your measure using DAX below and check if the issue can be resolved:
Cumulative sales = TOTALYTD ( SUM ( orders[Sales Value] ), Date[Date] )
Regards,
Jimmy Tao
Thank you, it was the solution I searched for
Hi @Anonymous
use the Quick measure "Year-to-date total".
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |