Returns a set of dates in the year up to the last date visible in the filter context.
The name of a column containing dates or a one column table containing dates.
End of year date.
A table containing a single column of date values.
The dates argument can be any of the following:
- A reference to a date/time column. Only in this case a context transition applies because the column reference is replaced by
- A table expression that returns a single column of date/time values.
- A Boolean expression that defines a single-column table of date/time values.
The result table includes only dates that exist in the dates column.
DATESYTD ( <Dates>[, <YearEndDate>] )
DATESBETWEEN ( <Dates>, STARTOFYEAR ( LASTDATE ( <Dates> )[, <YearEndDate>] ), LASTDATE ( <Dates> ) )
Learn more about DATESYTD in the following articles:
Time Intelligence in Power BI Desktop
In Power BI Desktop (as of February 2016) you have to use DAX to apply calculations over dates (such as year-to-date, year-over-year, and others), but you do not have the Mark as Date Table feature. This article describes which scenarios are impacted and the possible workarounds. » Read more
International year_end_date for YTD functions in DAX
If you used the DATESYTD and TOTALYTD functions in DAX, you might have noticed that the optional parameter year_end_date is a string defining the last day of the year. This article describes what are the formats allowed in that parameter. » Read more
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/datesytd-function-dax