DATESINPERIOD

DATESINPERIOD Returns a table that contains a column of dates that begins with the start_date and continues for the specified number_of_intervals.


Syntax

DATESINPERIOD(dates,start_date,number_of_intervals,interval)

Parameters

Dates – A column that contains dates.

Start_date – A date expression.

Number_of_intervals – An integer that specifies the number of intervals to add to or subtract from the dates.

Interval – The interval by which to shift the dates. The value for interval can be one of the following: year, quarter, month, day

Return Value

A table containing a single column of date values.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Time Intelligence Functions / DATESINPERIOD