Calculate cumulation by month

[guil-laume]

Hi to all,

In the foloowing matrix, I would like to add a row with the cumulative sum of the row "Montant HT".

I have no idea of how doing this. Can aynone help me ?

[v-jayw-msft · Accepted solution]

Hi @guil-laume ,

Please refer this common cumulative sum formula.

_cumulative = sumx(filter(allselected('table'),[year]=selectedvalue([year])&&[month]<=max([month])),[Montant HT])

Best Regards,

Jay

[amitchandak]

@guil-laume , depends you need yearly or overall, with help from date table, and use month from date table in visual

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

or

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