Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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".
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |