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
mikebi
Helper III
Helper III

YTD Calculation

Hello,

 

Are these two measures the same and equivalent?  Is there a reason to use one over the other?  I think when I first started learning DAX I would write out my measures as in the Calc Measure but now there are functions that can be used.

 

Thank You,

 

Michael

 

YTD Revenue =
CALCULATE(
[Total Revenue],
DATESYTD(
'Calendar Lookup'[Date]
)
)

 

YTD Revenue Calc =
Var _Year = SelectedValue('Calendar Lookup'[Year])
Var _Month = SelectedValue('Calendar Lookup'[Month])

Var _Amount = Calculate([Total Revenue],Filter(All('Calendar Lookup'),'Calendar Lookup'[Year]=_Year && 'Calendar Lookup'[Month]<=_Month))

Return _Amount

 

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@mikebi I don't believe that they are equivalent. DATESYTD should bring back all of the dates for the current year and the second one only brings back dates for the same year but only if the month is less than the selected month. I personally wouldn't use either of them. Better Year to Date Total - Microsoft Fabric Community 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@mikebi I don't believe that they are equivalent. DATESYTD should bring back all of the dates for the current year and the second one only brings back dates for the same year but only if the month is less than the selected month. I personally wouldn't use either of them. Better Year to Date Total - Microsoft Fabric Community 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hello, 

I assume the purpose of the Union is to generate random data?

I like the solution.

 

Michael

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.