Forum Discussion
admin11
Memorable Member
Memorable MemberHow to use TOTALYTD replace DATESYTD ?
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
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
1 Reply
- amitchandak
Super User
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