datesmtd-function-dax.md

description	title
Learn more about: DATESMTD	DATESMTD function (DAX) | Microsoft Docs

DATESMTD

[!INCLUDEapplies-to-measures-columns-tables-visual-calculations-discouraged]

Returns a table that contains a column of the dates for the month to date, in the current context.

Syntax

DATESMTD(<dates>)  

Parameters

Term	Definition
dates	A column that contains dates.

Return value

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.

• 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.

  [!NOTE]
  Constraints on Boolean expressions are described in the topic, CALCULATE function.

• [!INCLUDE function-not-supported-in-directquery-mode]

Example

The following sample formula creates a measure that calculates the 'Month To Date Total' for Internet Sales.

= CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), DATESMTD(DateTime[DateKey]))  

Related content

Time intelligence functions
Date and time functions
DATESYTD function
DATESQTD function