Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
admin11
Memorable Member
Memorable Member

How 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

1 ACCEPTED SOLUTION
amitchandak
Super User
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

View solution in original post

1 REPLY 1
amitchandak
Super User
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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.