A quarterly cumulative shows me the following months

[Anonymous]

I used the DAX formula to accumulate sales for the last three months but I complete the figures for the next 2 months and do not want to see them. I tried Filter but I can't get him to delete me for the next few months (the 6th and 7th)

The formula I use is

_MEDIA MOBILE TRIMESTRE - CALCULATE('_TB MEASURES'[_TOTAL SALE Current Year],

DATESINPERIOD('MY CALENDAR'[Date],

LASTDATE('MY CALENDAR'[Date]),-3,MONTH))

And it shows me

[v-diye-msft]

Hi,

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[amitchandak]

@Anonymous , Try adding a filter like

_MEDIA MOBILE TRIMESTRE - CALCULATE('_TB MEASURES'[_TOTAL SALE Current Year],
DATESINPERIOD('MY CALENDAR'[Date],
LASTDATE('MY CALENDAR'[Date]),-3,MONTH) , 'MY CALENDAR'[Date] <=eomonth(today(),-2)+1)

eomonth(today(),-2)

-2 can be -3 or -1 depend on need