DATESMTD DAX Function

The DATESMTD function returns a table that contains a single column of the dates for the month to date, in the current context. For example, if the first date in the column is 7 July 2009, then it returns all the dates from 1 July 2009 to 31st July 2009.

DAX Syntax DATESMTD(dates)

The parameter dates is a column containing dates.

Example: The following sample formula creates a measure that calculates the Month To Date Total.

DAX