Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago

How to modify expression return Feb 2021 Amount ?

Hi All   I have below YTD expression working fine :-   _YTD EXP = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_EXP] = "EXP")   Can some one help me to modify the above ...
Need Help
admin11's avatar
admin11
Memorable Member
5 years ago

mohammedadnant 

i Just finish watching the youtube.

I try to change the Y to M :-

 

_MTD EXP = CALCULATE(CALCULATE(GL[AMOUNT],DATESMTD('Date'[Date],"12/31")), GL[1_EXP] = "EXP")
 
I get error msg :-

 

mohammedadnant's avatar
mohammedadnant
Impactful Individual
5 years ago

HI admin11 

Try this 2 formulas..

 

TOTALMTD(GL[AMOUNT], 'DATE'[DATE], ALL('DATE'[DATE]), GL[1_EXP] ="EXP")

 

TOTALYTD(GL[AMOUNT], 'DATE'[DATE], ALL('DATE'[DATE]), GL[1_EXP] ="EXP", "02/28")

 

Thanks & Regards,

Mohammed Adnan