Show rolling total of data till last month only

[Anonymous]

Hi All,

I have a DAX measure : 

Dist RT > Max running total in Month =

CALCULATE(

    [Dist RT > Max],

    FILTER(

        CALCULATETABLE(

            SUMMARIZE('Calender', 'Calender'[Date].[MonthNo], 'Calender'[Date].[Month]),

            ALLSELECTED('Calender')

        ),

        ISONORAFTER(

            'Calender'[Date].[MonthNo], MAX('Calender'[Date].[MonthNo]), DESC,

            'Calender'[Date].[Month], MAX('Calender'[Date].[Month]), DESC

        )

    )

)

Which Gives me a chart like this when plotted against Month.

How do I change the above measure to stop it at March as my data is till March. Also,

When I manually filter it till March, the x axis shows only3 months,

I need it to show all 12 months with April to December as empty.

[amitchandak]

@Anonymous , with help from date table try like

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

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

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,-1,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,-1,REL, ALLSELECTED('date'[date]),ORDERBY('Date'[date],ASC)))

Running Total/ Cumulative:
https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc