Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
deevaker's avatar
deevaker
Resolver I
3 years ago

Hi Anonymous,

Are you looking at something like below ? if yes, then you can use this measure :

Cumulative Total by year = SUMX(FILTER(ALL('Table'),year('Table'[date])<=YEAR(MIN('Table'[date])) ),[value])

 

Thanks,

Deevaker
+91-9711975011
[email protected]

https://www.linkedin.com/in/deevakerg/