Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts, what is differnce between two following measures ?
Expenses YTD =calculate(
[Expenses],
DATESYTD('Date'[Date]
))
Expenses_YTD = calculate(
[Expenses],
CALCULATETABLE(
DATESYTD('Date'[Date])
))
Solved! Go to Solution.
@koorosh , Datesytd returning a table with a single column of dates.
You are taking that in calculatetable and returning that in the second case. The almost same thing is returned
https://docs.microsoft.com/en-us/dax/datesytd-function-dax
@koorosh , Datesytd returning a table with a single column of dates.
You are taking that in calculatetable and returning that in the second case. The almost same thing is returned
https://docs.microsoft.com/en-us/dax/datesytd-function-dax
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
100 | |
84 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |