DATESYTD DAX Function (Time Intelligence) Context Transition
Zwraca zestaw dat w roku poprzedzającym bieżącą datę.
Syntax
Parameter | Attributes | Description |
---|---|---|
Dates |
Nazwa kolumny zawierającej daty lub jednokolumnowej tabeli zawierającej daty. |
|
YearEndDate | Optional |
Data końca roku. |
Return values
A table containing a single column of date values.
Remarks
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> ) )
Related articles
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
Related functions
Other related functions are:
Last update: Dec 14, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Daniel Tenke
MSDN documentation: https://docs.microsoft.com/en-us/dax/datesytd-function-dax