DATESINPERIOD DAX Function (Time Intelligence)

Returns the dates from the given period.

Syntax

DATESINPERIOD ( <Dates>, <StartDate>, <NumberOfIntervals>, <Interval> )

Parameter	Attributes	Description
Dates		A column reference containing dates.
StartDate		Start date.
NumberOfIntervals		The number of intervals.
Interval		One of: Day, Month, Quarter, Year.

Return values

Table A table with a single column.

A table containing a single column of date values.

Remarks

The dates argument must be a reference to a date/time column.
The result table includes only dates that exist in the dates column.

Examples

The following expression evaluates the measure Sales Amount in the last 12 months starting from the last day of the period in the filter context.

Sales Moving Annual Total =
CALCULATE (
    [Sales Amount],
    DATESINPERIOD (
        'Date'[Date],
        MAX ( 'Date'[Date] ),
        -1,
        YEAR
    )
)

Last update: Feb 6, 2019 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Jes Hansen

MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/datesinperiod-function-dax