Forum Discussion
Cumulative Total
I am looking to calculate a cumulative total of a column based on another column by sequential dates. There are orders for multiple years in the same table. The formula I currently have is making it ...
Hi Anonymous,
Let's assume you already have a measure for calculating cumulative total. You can use the this formula to make it go year by year instead of all data:
Cumulative Year by Year = CALCULATE([Total],DATESYTD('Date'[Date],"12/31"))
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison
Shaurya - Would this only show for 1 year?