Running Total Across Months

[tegar219]

Hi all, 

I've tried searching through previous threads but have come up short with a solution that seems to work in my case.

I have material id's as rows and monthly production as columns. I would like the production to be cumulative across the months rather than as production by month as seen above. The formula I tried in the box above does not seem to work as expected.

Thank you and would appreciate any help.

[amitchandak]

@tegar219 , if you need over all cumm

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

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

only till month level

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

QTR

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD('Date'[Date]))

Yearly

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date]))