When i try to convert YTD expression to LYTD i get null display

[admin11]

Hi All

I have below YTD expression working fine :-

Expense_YTD _ =

var _max = date(year(today())-0,month(today()),day(today()))

return

TOTALYTD(GL[AMOUNT],'Date'[Date], GL[1_EXP] = "EXP",'Date'[Date]<=_max)

From the above expression , i try to modify to LYTD , i get null return :-

My PBI file :-

https://www.dropbox.com/s/cbltgm0aobgltzf/PBT_V2021_382%20TI_SI_GL%20LYTD%20expense%20return%20null....

Paul

[amitchandak]

@admin11 , Please check the file attached after signature

Expense_LYTD_ = 

var _max = date(year(today())-1,month(today()),day(today()))

return

CALCULATE(TOTALYTD(GL[AMOUNT],'Date'[Date], GL[1_EXP] = "EXP"),'Date'[Date]<=_max)

[admin11]

@amitchandak 

Your expression working fine.

But when i click on month jan till march , i cannot get the following :-

Jan return -376 m

Feb return -488 m

Mar return -501 m

it keep display -501m

Below link is my PBI file :-

https://www.dropbox.com/s/38u4j3fpumy217k/PBT_V2021_382%20TI_SI_GL%20SAMPLE%20how%20to%20get%20jan%2...

Paul