DATESMTD

Applies to: Calculated column Calculated table Measure Visual calculation

Note

This function is discouraged for use in visual calculations as it likely returns meaningless results.

For date column input, returns a table that contains a column of the dates for the month to date, in the current context.
For calendar input, returns a table for the month to date, in the current context. The table contains all primary tagged columns and all time related columns.

Syntax

DATESMTD(<dates> or <calendar>)

Parameters

Term	Definition
dates or calendar	A column that contains dates or a calendar reference.

Return value

For date column input, a table containing a single column of date values.
For calendar input, a table that contains all primary tagged columns and all time related columns.

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.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

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] )
)

Example for calendar based time intelligence

The following sample formula creates a measure that calculates the 'Monthly Running Total' for Internet sales uing fiscal calendar.

=
CALCULATE (
    SUM ( InternetSales_USD[SalesAmount_USD] ),
    DATESMTD ( FiscalCalendar )
)

Related content

Time intelligence functions Date and time functions DATESWTD function DATESQTD function DATESYTD function