cancel
Showing results for
Did you mean:

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

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
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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2
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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Helper III

Hello,

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

I like the solution.

Michael

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors