Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |