Show last n month by category and date with 0 instead of blank

[Datavizuserpbi]

Hello,

I created a measure to get the amount of the previous month with the last date selected in a slicer .

If i want  to show 4 last month by level i get this

Level	aout 2022	sept 2022	oct 2022	nov 2022
Level 1	23	24	65	2
Level 2	45	80	764	6754
....

With this measure - > Last n month =

var y=MAX(DateTable[Date])

return CALCULATE([Amount],DATESBETWEEN(Datetable[Date],EOMONTH(y,-12),y))

I want to return 0 if "Last n month" return blank by adding 0 in the measure  but when I do this, the filter does not work anymore and i get this :

Level	mai 2022	juin 2022	juil 2022	aout 2022	sept 2022	oct 2022	nov 2022
Level 1	0	0	0	23	24	65	2
Level 2	0	0	0	45	80	764	6754
....

How can i do to get 0 and make the filter "DATEBETWEEN" work?

Thank you

[Greg_Deckler]

@Datavizuserpbi Try:

 Last n month =
var y=MAX(DateTable[Date])
return CALCULATE([Amount],DATESBETWEEN(Datetable[Date],EOMONTH(y,-12),y)) + 0

[Datavizuserpbi]

Hello, I tried but it's not working