Returns a set of dates in the month up to the last date visible in the filter context.
The name of a column containing dates or a one column table containing dates.
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.
DATESMTD ( <Dates> )
DATESBETWEEN ( <Dates>, STARTOFMONTH ( LASTDATE ( <Dates> ) ), LASTDATE ( <Dates> ) )
Learn more about DATESMTD 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
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/datesmtd-function-dax