How to add condition month=2 to my YTD expression ?

[admin11]

Hi All

Below YTD expense work fine :- 

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

Can i add filter for month=2 , So that i only get feb 2021 amount. Expected amount = 182m

https://www.dropbox.com/s/eguykiaxtpc6bfz/PBT_V2021_382%20TI_SI_GL%20how%20to%20get%20exp%20for%20fe...

Above link is my PBI file 

Paul

My PBI file :-

Paul

[amitchandak · Accepted solution]

@admin11 , for that you can need MTD or LMTD

MTD Sales = CALCULATE(GL[AMOUNT],DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(GL[AMOUNT],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(GL[AMOUNT],previousmonth('Date'[Date]))