My previous month Exp return null amount

[admin11]

Hi All

I have below YTD expression working fine :-

_YTD EXP = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_EXP] = "EXP")

Since i need to get Previous month amount , i modify above expression to below :-

EXP PREVIOUS Sales = CALCULATE(GL[AMOUNT],previousmonth('Date'[Date]),GL[1_EXP] = "EXP")

But i get null display.

https://www.dropbox.com/s/x4kh3k5ljvubai7/PBT_V2021_382%20TI_SI_GL%20Previous%20month%20EXP%20return...

Above link is my PBI file

Paul

[amitchandak · Accepted solution]

@admin11 , no date is selected so previous month is not coming. I added month and year filter and able to get that.

Without a date filter try like

EXP PREVIOUS Sales = CALCULATE(GL[AMOUNT],eomonth('Date'[Date],0) = eomonth(today(),-1),GL[1_EXP] = "EXP")