How to use TOTALYTD replace DATESYTD ?

[admin11]

Hi All

I have this expression working fine :-

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

May i know how to modify the above expression using  :-

TOTALYTD

Paul

[amitchandak · Accepted solution]

@admin11 , try like

Expense_YTD = TOTALYTD(GL[AMOUNT],'Date'[Date], GL[1_EXP] = "EXP","12/31")

refer:https://docs.microsoft.com/en-us/dax/totalytd-function-dax