YTD

Question

Hello Experts, what is differnce between two following measures ?Expenses YTD =calculate(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Expenses],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DATESYTD('Date'[Date]&nbsp;&nbsp;&nbsp; ))&nbsp;Expenses_YTD = calculate(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Expenses],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DATESYTD('Date'[Date])&nbsp;&nbsp;&nbsp; ))&nbsp;

amitchandak · Accepted Answer

koorosh , Datesytd returning a table with a single column of dates. 
&nbsp;
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

Forum Discussion

YTD

1 Reply

Related content

YTD and YTD PY for multiple measures

YTD vs Last Year YTD

Matrix displaying quarterly, YTD, YTD PY, and YOY Var

YTD

Cummulative YTD Totals By Month Error