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
v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi Anonymous 

Thanks for reaching out to us.

please try this measure

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

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.