Forum Discussion
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 expression to return Feb 2021 amount .
My PBI file :-
Paul
10 Replies
Hi admin11
Good day,
Please check this video might help, https://youtu.be/WiuXJGWwong
Thanks & Regards,
Mohammed Adnan
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 :-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
