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 u...
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
amitchandak
Super User
Super Useradmin11 , 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