Calculate cummulative total Last month -1

[rajveer1117]

Hi,

Need help in solving the below issue.

I have a data from January to decemeber but need to show only data till last month -1.

Example: the first table show's the total qty , when i calculated the cummulative total it is showing for dec also. I tried to filter out but is not now working.

[amitchandak · Accepted solution]

@rajveer1117 ,

Try with date table like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=maxx(date,dateadd(date[date]),-1,month)))