Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cumulative Sum or Running Total

Hi community,   I have a little problem calculating a cumulative sum (or running total) via dax. As shown by my data model, I have two fact tables and a calendar table linked together via the "Date...
Cumulative Sum
DAX Commands and Tips
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

We can typically get Cumulative  as measure like this

 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=maxx(date,date[date])))
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(Sales[Sales Date])))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amitchandak,

 

You can see the sample data and data model in the screen above.

 

Is everything clear or you need a more details?

 

Thanks in advance.

Fabio