DATESYTD DAX Function (Time Intelligence) Context Transition

Returns a set of dates in the year up to the last date visible in the filter context.

Syntax

DATESYTD ( <Dates> [, <YearEndDate>] )

Parameter	Attributes	Description
Dates		The name of a column containing dates or a one column table containing dates.
YearEndDate	Optional	End of year date.

Table A table with a single column.

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
- CALCULATETABLE ( DISTINCT ( <Dates> ) )
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.

The syntax:

DATESYTD ( <Dates>[, <YearEndDate>] )

corresponds to:

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