DATESINPERIOD DAX Function (Time Intelligence)

Returns the dates from the given period.

Syntax

DATESINPERIOD ( <Dates>, <StartDate>, <NumberOfIntervals>, <Interval> [, <EndBehavior>] )

Parameter	Attributes	Description
Dates		A column reference containing dates.
StartDate		Start date.
NumberOfIntervals		The number of intervals.
Interval		One of: Day, Week, Month, Quarter, Year.
EndBehavior	Optional	For calendar time intelligence only. An enumeration that defines DatesInPeriod behavior for endpoint and interval calculation. Valid values are: PRECISE, ENDALIGNED. Default value is PRECISE.

Return values

Table A table with a single column.

A table containing a single column of unique date values.

Notes

In order to use any time intelligence calculation, you need a well-formed date table. The Date table must satisfy the following requirements:

All dates need to be present for the years required. The Date table must always start on January 1 and end on December 31, including all the days in this range. If the report only references fiscal years, then the date table must include all the dates from the first to the last day of a fiscal year. For example, if the fiscal year 2008 starts on July 1, 2007, then the Date table must include all the days from July 1, 2007 to June 30, 2008.
There needs to be a column with a DateTime or Date data type containing unique values. This column is usually called Date. Even though the Date column is often used to define relationships with other tables, this is not required. Still, the Date column must contain unique values and should be referenced by the Mark as Date Table feature. In case the column also contains a time part, no time should be used – for example, the time should always be 12:00 am.
The Date table must be marked as a date table in the model, in case the relationship between the Date table and any other table is not based on the Date.

The result of time intelligence functions has the same data lineage as the date column or table provided as an argument.

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.
A BLANK value provided as StartDate uses MIN ( Dates ) as StartDate argument.

For performance reasons, consider WINDOW instead of DATESINPERIOD whenever possible to take advantage of WINDOW optimization.

The EndBehavior argument is valid only when the first argument is a calendar. If you use a date column, DATESINPERIOD accepts only four arguments. EndBehavior has two values: PRECISE and ENDALIGNED. The default is PRECISE.

DATESINPERIOD starts on the start date. It moves back or forward by the number of intervals. This gives a boundary date. The result has the dates between the start date and the boundary date. The boundary date is not in the result.

With PRECISE, DAX finds the boundary date by its position in the period. For example, February 28 is day 28 of February. One month back, the boundary date is January 28. Thus, the result starts on January 29.

With ENDALIGNED, DAX does the same calculation, with one exception. If the start date is the last day of its period, the boundary date is the last day of the other period. For example, February 28 is the last day of February. One month back, the boundary date is January 31. Thus, the result is all of February.

If the start date is not the last day of its period, PRECISE and ENDALIGNED return the same dates. Use ENDALIGNED when you want complete months or complete quarters, for example the last six complete months.

With a calendar, the YEAR interval uses the day of the year, not the month and the day. A leap year has 366 days. Thus, the result can be different by one day from the result with a date column. The calendar also defines the year. With a fiscal calendar, the year is the fiscal year.

» 6 related articles

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

--  DATESINPERIOD returns an entire period, given a reference date and
--  the period.

--  The first query returns 1 day, starting from August 15, 2008
EVALUATE
    DATESINPERIOD ( 
        'Date'[Date],           -- Return dates in Date[Date]
        DATE ( 2008, 08, 15 ),  -- Starting from 08/15/2008
        1,                      -- the set needs to contain 1
        DAY                     -- day
    )
    
--  The second query returns 3 days, starting from August 15, 2008
EVALUATE
    DATESINPERIOD ( 
        'Date'[Date],           -- Return dates in Date[Date]
        DATE ( 2008, 08, 15 ),  -- Starting from 08/15/2008
        3,                      -- the set needs to contain 3
        DAY                     -- days
    )

--  The second query returns an empty table because we reques 0 days
EVALUATE
    DATESINPERIOD ( 
        'Date'[Date],           -- Return dates in Date[Date]
        DATE ( 2008, 08, 15 ),  -- Starting from 08/15/2008
        0,                      -- the set needs to contain 0
        DAY                     -- days
    )

Date
2008-08-15

Date
2008-08-15
2008-08-16
2008-08-17

--  When the offset is negative, DATESINPERIOD goes back to find
--  the dates to use

--  The first query returns 2 days, the last one is August 15, 2008
EVALUATE
    DATESINPERIOD ( 
        'Date'[Date],           -- Return dates in Date[Date]
        DATE ( 2008, 08, 15 ),  -- Starting from 08/15/2008
        -2,                     -- the set needs to contain 2
        DAY                     -- days, going back in time
    )
    
--  The second query returns an entire month (31 days), the last day is August 15, 2008.
--  The number of days for a month might vary between 28 and 31, depending on the month.
EVALUATE
    DATESINPERIOD ( 
        'Date'[Date],           -- Return dates in Date[Date]
        DATE ( 2008, 08, 15 ),  -- Starting from 08/15/2008
        -1,                     -- going back one
        MONTH                   -- month
    )

Date
2008-08-14
2008-08-15

Date
2008-07-16
2008-07-17
2008-07-18
2008-07-19
2008-07-20
2008-07-21
2008-07-22
2008-07-23
2008-07-24
2008-07-25
2008-07-26
2008-07-27
2008-07-28
2008-07-29
2008-07-30
2008-07-31
2008-08-01
2008-08-02
2008-08-03
2008-08-04
2008-08-05
2008-08-06
2008-08-07
2008-08-08
2008-08-09
2008-08-10
2008-08-11
2008-08-12
2008-08-13
2008-08-14
2008-08-15

--
--  In this example we compute the moving annual average of [Sales Amount]
--  only when DATESINPERIOD contains 12 months of sales
--
DEFINE
    MEASURE Sales[Sales MAT] =
        VAR OneYearBack =
            DATESINPERIOD ( 'Date'[Date], MAX ( 'Date'[Date] ), -1, YEAR )
        VAR Result =
            CALCULATE (
                VAR NumberOfMonths =
                    COUNTROWS ( SUMMARIZE ( Sales, 'Date'[Calendar Year Month Number] ) )
                VAR SalesMAT = [Sales Amount]
                VAR Result   = IF ( NumberOfMonths = 12, SalesMAT / NumberOfMonths )
                RETURN
                    Result,
                OneYearBack
            )
        RETURN
            Result
EVALUATE
SUMMARIZECOLUMNS (
    'Date'[Calendar Year Month Number],
    'Date'[Calendar Year Month],
    TREATAS ( { "CY 2008" }, 'Date'[Calendar Year] ),
    "Sales Amount", [Sales Amount],
    "Sales MAT", [Sales MAT]
)
ORDER BY [Calendar Year Month Number]

Calendar Year Month Number	Calendar Year Month	Sales Amount	Sales MAT
200801	2008-01-01	656,766.69	931,038.71
200802	2008-02-01	600,080.00	906,784.06
200803	2008-03-01	559,538.52	873,304.83
200804	2008-04-01	999,667.17	862,601.69
200805	2008-05-01	893,231.96	859,021.63
200806	2008-06-01	845,141.60	847,591.39
200807	2008-07-01	890,547.41	844,925.09
200808	2008-08-01	721,560.95	825,652.29
200809	2008-09-01	963,437.23	821,782.97
200810	2008-10-01	719,792.99	805,576.26
200811	2008-11-01	1,156,109.32	833,118.55
200812	2008-12-01	921,709.14	827,298.58

The following query uses February 29, 2008 as start date. It goes back one interval for each interval type and each EndBehavior value. The last row of each group uses a date column instead of a calendar. Only MONTH shows a difference: ENDALIGNED returns the full month of February.

EVALUATE
VAR T1 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, DAY )
VAR T2 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, DAY, PRECISE )
VAR T3 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, DAY, ENDALIGNED )
VAR T4 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 2, 29 ), -1, DAY )
VAR T5 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, MONTH )
VAR T6 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, MONTH, PRECISE )
VAR T7 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, MONTH, ENDALIGNED )
VAR T8 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 2, 29 ), -1, MONTH )
VAR T9 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, QUARTER )
VAR T10 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, QUARTER, PRECISE )
VAR T11 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, QUARTER, ENDALIGNED )
VAR T12 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 2, 29 ), -1, QUARTER )
VAR T13 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, YEAR )
VAR T14 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, YEAR, PRECISE )
VAR T15 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, YEAR, ENDALIGNED )
VAR T16 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 2, 29 ), -1, YEAR )
RETURN
  UNION (
    ROW ( "Interval", "DAY", "EndBehavior", "(omitted)", "First", MINX ( T1, 'Date'[Date] ), "Last", MAXX ( T1, 'Date'[Date] ), "Days", COUNTROWS ( T1 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "PRECISE", "First", MINX ( T2, 'Date'[Date] ), "Last", MAXX ( T2, 'Date'[Date] ), "Days", COUNTROWS ( T2 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "ENDALIGNED", "First", MINX ( T3, 'Date'[Date] ), "Last", MAXX ( T3, 'Date'[Date] ), "Days", COUNTROWS ( T3 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T4, 'Date'[Date] ), "Last", MAXX ( T4, 'Date'[Date] ), "Days", COUNTROWS ( T4 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "(omitted)", "First", MINX ( T5, 'Date'[Date] ), "Last", MAXX ( T5, 'Date'[Date] ), "Days", COUNTROWS ( T5 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "PRECISE", "First", MINX ( T6, 'Date'[Date] ), "Last", MAXX ( T6, 'Date'[Date] ), "Days", COUNTROWS ( T6 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "ENDALIGNED", "First", MINX ( T7, 'Date'[Date] ), "Last", MAXX ( T7, 'Date'[Date] ), "Days", COUNTROWS ( T7 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T8, 'Date'[Date] ), "Last", MAXX ( T8, 'Date'[Date] ), "Days", COUNTROWS ( T8 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "(omitted)", "First", MINX ( T9, 'Date'[Date] ), "Last", MAXX ( T9, 'Date'[Date] ), "Days", COUNTROWS ( T9 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "PRECISE", "First", MINX ( T10, 'Date'[Date] ), "Last", MAXX ( T10, 'Date'[Date] ), "Days", COUNTROWS ( T10 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "ENDALIGNED", "First", MINX ( T11, 'Date'[Date] ), "Last", MAXX ( T11, 'Date'[Date] ), "Days", COUNTROWS ( T11 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T12, 'Date'[Date] ), "Last", MAXX ( T12, 'Date'[Date] ), "Days", COUNTROWS ( T12 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "(omitted)", "First", MINX ( T13, 'Date'[Date] ), "Last", MAXX ( T13, 'Date'[Date] ), "Days", COUNTROWS ( T13 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "PRECISE", "First", MINX ( T14, 'Date'[Date] ), "Last", MAXX ( T14, 'Date'[Date] ), "Days", COUNTROWS ( T14 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "ENDALIGNED", "First", MINX ( T15, 'Date'[Date] ), "Last", MAXX ( T15, 'Date'[Date] ), "Days", COUNTROWS ( T15 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T16, 'Date'[Date] ), "Last", MAXX ( T16, 'Date'[Date] ), "Days", COUNTROWS ( T16 ) )
  )

Interval	EndBehavior	First	Last	Days
DAY	(omitted)	2008-02-29	2008-02-29	1
DAY	PRECISE	2008-02-29	2008-02-29	1
DAY	ENDALIGNED	2008-02-29	2008-02-29	1
DAY	classic ‘Date'[Date]	2008-02-29	2008-02-29	1
MONTH	(omitted)	2008-01-30	2008-02-29	31
MONTH	PRECISE	2008-01-30	2008-02-29	31
MONTH	ENDALIGNED	2008-02-01	2008-02-29	29
MONTH	classic ‘Date'[Date]	2008-02-01	2008-02-29	29
QUARTER	(omitted)	2007-11-30	2008-02-29	92
QUARTER	PRECISE	2007-11-30	2008-02-29	92
QUARTER	ENDALIGNED	2007-11-30	2008-02-29	92
QUARTER	classic ‘Date'[Date]	2007-12-01	2008-02-29	91
YEAR	(omitted)	2007-03-02	2008-02-29	365
YEAR	PRECISE	2007-03-02	2008-02-29	365
YEAR	ENDALIGNED	2007-03-02	2008-02-29	365
YEAR	classic ‘Date'[Date]	2007-03-01	2008-02-29	366

March 31, 2008 is the end of a month and of a quarter. With QUARTER, PRECISE returns 92 days, while ENDALIGNED returns exactly the first quarter of 2008.

EVALUATE
VAR T1 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, DAY )
VAR T2 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, DAY, PRECISE )
VAR T3 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, DAY, ENDALIGNED )
VAR T4 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 3, 31 ), -1, DAY )
VAR T5 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, MONTH )
VAR T6 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, MONTH, PRECISE )
VAR T7 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, MONTH, ENDALIGNED )
VAR T8 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 3, 31 ), -1, MONTH )
VAR T9 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, QUARTER )
VAR T10 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, QUARTER, PRECISE )
VAR T11 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, QUARTER, ENDALIGNED )
VAR T12 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 3, 31 ), -1, QUARTER )
VAR T13 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, YEAR )
VAR T14 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, YEAR, PRECISE )
VAR T15 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, YEAR, ENDALIGNED )
VAR T16 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 3, 31 ), -1, YEAR )
RETURN
  UNION (
    ROW ( "Interval", "DAY", "EndBehavior", "(omitted)", "First", MINX ( T1, 'Date'[Date] ), "Last", MAXX ( T1, 'Date'[Date] ), "Days", COUNTROWS ( T1 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "PRECISE", "First", MINX ( T2, 'Date'[Date] ), "Last", MAXX ( T2, 'Date'[Date] ), "Days", COUNTROWS ( T2 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "ENDALIGNED", "First", MINX ( T3, 'Date'[Date] ), "Last", MAXX ( T3, 'Date'[Date] ), "Days", COUNTROWS ( T3 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T4, 'Date'[Date] ), "Last", MAXX ( T4, 'Date'[Date] ), "Days", COUNTROWS ( T4 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "(omitted)", "First", MINX ( T5, 'Date'[Date] ), "Last", MAXX ( T5, 'Date'[Date] ), "Days", COUNTROWS ( T5 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "PRECISE", "First", MINX ( T6, 'Date'[Date] ), "Last", MAXX ( T6, 'Date'[Date] ), "Days", COUNTROWS ( T6 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "ENDALIGNED", "First", MINX ( T7, 'Date'[Date] ), "Last", MAXX ( T7, 'Date'[Date] ), "Days", COUNTROWS ( T7 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T8, 'Date'[Date] ), "Last", MAXX ( T8, 'Date'[Date] ), "Days", COUNTROWS ( T8 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "(omitted)", "First", MINX ( T9, 'Date'[Date] ), "Last", MAXX ( T9, 'Date'[Date] ), "Days", COUNTROWS ( T9 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "PRECISE", "First", MINX ( T10, 'Date'[Date] ), "Last", MAXX ( T10, 'Date'[Date] ), "Days", COUNTROWS ( T10 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "ENDALIGNED", "First", MINX ( T11, 'Date'[Date] ), "Last", MAXX ( T11, 'Date'[Date] ), "Days", COUNTROWS ( T11 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T12, 'Date'[Date] ), "Last", MAXX ( T12, 'Date'[Date] ), "Days", COUNTROWS ( T12 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "(omitted)", "First", MINX ( T13, 'Date'[Date] ), "Last", MAXX ( T13, 'Date'[Date] ), "Days", COUNTROWS ( T13 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "PRECISE", "First", MINX ( T14, 'Date'[Date] ), "Last", MAXX ( T14, 'Date'[Date] ), "Days", COUNTROWS ( T14 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "ENDALIGNED", "First", MINX ( T15, 'Date'[Date] ), "Last", MAXX ( T15, 'Date'[Date] ), "Days", COUNTROWS ( T15 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T16, 'Date'[Date] ), "Last", MAXX ( T16, 'Date'[Date] ), "Days", COUNTROWS ( T16 ) )
  )

Interval	EndBehavior	First	Last	Days
DAY	(omitted)	2008-03-31	2008-03-31	1
DAY	PRECISE	2008-03-31	2008-03-31	1
DAY	ENDALIGNED	2008-03-31	2008-03-31	1
DAY	classic ‘Date'[Date]	2008-03-31	2008-03-31	1
MONTH	(omitted)	2008-03-01	2008-03-31	31
MONTH	PRECISE	2008-03-01	2008-03-31	31
MONTH	ENDALIGNED	2008-03-01	2008-03-31	31
MONTH	classic ‘Date'[Date]	2008-03-01	2008-03-31	31
QUARTER	(omitted)	2007-12-31	2008-03-31	92
QUARTER	PRECISE	2007-12-31	2008-03-31	92
QUARTER	ENDALIGNED	2008-01-01	2008-03-31	91
QUARTER	classic ‘Date'[Date]	2008-01-01	2008-03-31	91
YEAR	(omitted)	2007-04-02	2008-03-31	365
YEAR	PRECISE	2007-04-02	2008-03-31	365
YEAR	ENDALIGNED	2007-04-02	2008-03-31	365
YEAR	classic ‘Date'[Date]	2007-04-01	2008-03-31	366

The following query returns the last six months for different start dates. ENDALIGNED returns six complete months when the start date is the end of a short month.

EVALUATE
VAR T1 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -6, MONTH, PRECISE )
VAR T2 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -6, MONTH, ENDALIGNED )
VAR T3 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 31 ), -6, MONTH, PRECISE )
VAR T4 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 31 ), -6, MONTH, ENDALIGNED )
VAR T5 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -6, MONTH, PRECISE )
VAR T6 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -6, MONTH, ENDALIGNED )
VAR T7 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), -6, MONTH, PRECISE )
VAR T8 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), -6, MONTH, ENDALIGNED )
VAR T9 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -6, MONTH, PRECISE )
VAR T10 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -6, MONTH, ENDALIGNED )
RETURN
  UNION (
    ROW ( "StartDate", "2008-01-15", "EndBehavior", "PRECISE", "First", MINX ( T1, 'Date'[Date] ), "Last", MAXX ( T1, 'Date'[Date] ), "Days", COUNTROWS ( T1 ) ),
    ROW ( "StartDate", "2008-01-15", "EndBehavior", "ENDALIGNED", "First", MINX ( T2, 'Date'[Date] ), "Last", MAXX ( T2, 'Date'[Date] ), "Days", COUNTROWS ( T2 ) ),
    ROW ( "StartDate", "2008-01-31", "EndBehavior", "PRECISE", "First", MINX ( T3, 'Date'[Date] ), "Last", MAXX ( T3, 'Date'[Date] ), "Days", COUNTROWS ( T3 ) ),
    ROW ( "StartDate", "2008-01-31", "EndBehavior", "ENDALIGNED", "First", MINX ( T4, 'Date'[Date] ), "Last", MAXX ( T4, 'Date'[Date] ), "Days", COUNTROWS ( T4 ) ),
    ROW ( "StartDate", "2008-02-29", "EndBehavior", "PRECISE", "First", MINX ( T5, 'Date'[Date] ), "Last", MAXX ( T5, 'Date'[Date] ), "Days", COUNTROWS ( T5 ) ),
    ROW ( "StartDate", "2008-02-29", "EndBehavior", "ENDALIGNED", "First", MINX ( T6, 'Date'[Date] ), "Last", MAXX ( T6, 'Date'[Date] ), "Days", COUNTROWS ( T6 ) ),
    ROW ( "StartDate", "2007-02-28", "EndBehavior", "PRECISE", "First", MINX ( T7, 'Date'[Date] ), "Last", MAXX ( T7, 'Date'[Date] ), "Days", COUNTROWS ( T7 ) ),
    ROW ( "StartDate", "2007-02-28", "EndBehavior", "ENDALIGNED", "First", MINX ( T8, 'Date'[Date] ), "Last", MAXX ( T8, 'Date'[Date] ), "Days", COUNTROWS ( T8 ) ),
    ROW ( "StartDate", "2008-06-30", "EndBehavior", "PRECISE", "First", MINX ( T9, 'Date'[Date] ), "Last", MAXX ( T9, 'Date'[Date] ), "Days", COUNTROWS ( T9 ) ),
    ROW ( "StartDate", "2008-06-30", "EndBehavior", "ENDALIGNED", "First", MINX ( T10, 'Date'[Date] ), "Last", MAXX ( T10, 'Date'[Date] ), "Days", COUNTROWS ( T10 ) )
  )

StartDate	EndBehavior	First	Last	Days
2008-01-15	PRECISE	2007-07-16	2008-01-15	184
2008-01-15	ENDALIGNED	2007-07-16	2008-01-15	184
2008-01-31	PRECISE	2007-08-01	2008-01-31	184
2008-01-31	ENDALIGNED	2007-08-01	2008-01-31	184
2008-02-29	PRECISE	2007-08-30	2008-02-29	184
2008-02-29	ENDALIGNED	2007-09-01	2008-02-29	182
2007-02-28	PRECISE	2006-08-29	2007-02-28	184
2007-02-28	ENDALIGNED	2006-09-01	2007-02-28	181
2008-06-30	PRECISE	2007-12-31	2008-06-30	183
2008-06-30	ENDALIGNED	2008-01-01	2008-06-30	182

The following query uses QUARTER with negative and positive counts.

EVALUATE
VAR T1 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, QUARTER, PRECISE )
VAR T2 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, QUARTER, ENDALIGNED )
VAR T3 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -2, QUARTER, PRECISE )
VAR T4 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -2, QUARTER, ENDALIGNED )
VAR T5 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), 1, QUARTER, PRECISE )
VAR T6 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), 1, QUARTER, ENDALIGNED )
VAR T7 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -1, QUARTER, PRECISE )
VAR T8 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -1, QUARTER, ENDALIGNED )
VAR T9 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -2, QUARTER, PRECISE )
VAR T10 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -2, QUARTER, ENDALIGNED )
VAR T11 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), 1, QUARTER, PRECISE )
VAR T12 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), 1, QUARTER, ENDALIGNED )
VAR T13 = DATESINPERIOD ( Gregorian, DATE ( 2007, 12, 31 ), -1, QUARTER, PRECISE )
VAR T14 = DATESINPERIOD ( Gregorian, DATE ( 2007, 12, 31 ), -1, QUARTER, ENDALIGNED )
VAR T15 = DATESINPERIOD ( Gregorian, DATE ( 2007, 12, 31 ), -2, QUARTER, PRECISE )
VAR T16 = DATESINPERIOD ( Gregorian, DATE ( 2007, 12, 31 ), -2, QUARTER, ENDALIGNED )
VAR T17 = DATESINPERIOD ( Gregorian, DATE ( 2007, 12, 31 ), 1, QUARTER, PRECISE )
VAR T18 = DATESINPERIOD ( Gregorian, DATE ( 2007, 12, 31 ), 1, QUARTER, ENDALIGNED )
RETURN
  UNION (
    ROW ( "StartDate", "2008-03-31", "N", -1, "EndBehavior", "PRECISE", "First", MINX ( T1, 'Date'[Date] ), "Last", MAXX ( T1, 'Date'[Date] ), "Days", COUNTROWS ( T1 ) ),
    ROW ( "StartDate", "2008-03-31", "N", -1, "EndBehavior", "ENDALIGNED", "First", MINX ( T2, 'Date'[Date] ), "Last", MAXX ( T2, 'Date'[Date] ), "Days", COUNTROWS ( T2 ) ),
    ROW ( "StartDate", "2008-03-31", "N", -2, "EndBehavior", "PRECISE", "First", MINX ( T3, 'Date'[Date] ), "Last", MAXX ( T3, 'Date'[Date] ), "Days", COUNTROWS ( T3 ) ),
    ROW ( "StartDate", "2008-03-31", "N", -2, "EndBehavior", "ENDALIGNED", "First", MINX ( T4, 'Date'[Date] ), "Last", MAXX ( T4, 'Date'[Date] ), "Days", COUNTROWS ( T4 ) ),
    ROW ( "StartDate", "2008-03-31", "N", 1, "EndBehavior", "PRECISE", "First", MINX ( T5, 'Date'[Date] ), "Last", MAXX ( T5, 'Date'[Date] ), "Days", COUNTROWS ( T5 ) ),
    ROW ( "StartDate", "2008-03-31", "N", 1, "EndBehavior", "ENDALIGNED", "First", MINX ( T6, 'Date'[Date] ), "Last", MAXX ( T6, 'Date'[Date] ), "Days", COUNTROWS ( T6 ) ),
    ROW ( "StartDate", "2008-06-30", "N", -1, "EndBehavior", "PRECISE", "First", MINX ( T7, 'Date'[Date] ), "Last", MAXX ( T7, 'Date'[Date] ), "Days", COUNTROWS ( T7 ) ),
    ROW ( "StartDate", "2008-06-30", "N", -1, "EndBehavior", "ENDALIGNED", "First", MINX ( T8, 'Date'[Date] ), "Last", MAXX ( T8, 'Date'[Date] ), "Days", COUNTROWS ( T8 ) ),
    ROW ( "StartDate", "2008-06-30", "N", -2, "EndBehavior", "PRECISE", "First", MINX ( T9, 'Date'[Date] ), "Last", MAXX ( T9, 'Date'[Date] ), "Days", COUNTROWS ( T9 ) ),
    ROW ( "StartDate", "2008-06-30", "N", -2, "EndBehavior", "ENDALIGNED", "First", MINX ( T10, 'Date'[Date] ), "Last", MAXX ( T10, 'Date'[Date] ), "Days", COUNTROWS ( T10 ) ),
    ROW ( "StartDate", "2008-06-30", "N", 1, "EndBehavior", "PRECISE", "First", MINX ( T11, 'Date'[Date] ), "Last", MAXX ( T11, 'Date'[Date] ), "Days", COUNTROWS ( T11 ) ),
    ROW ( "StartDate", "2008-06-30", "N", 1, "EndBehavior", "ENDALIGNED", "First", MINX ( T12, 'Date'[Date] ), "Last", MAXX ( T12, 'Date'[Date] ), "Days", COUNTROWS ( T12 ) ),
    ROW ( "StartDate", "2007-12-31", "N", -1, "EndBehavior", "PRECISE", "First", MINX ( T13, 'Date'[Date] ), "Last", MAXX ( T13, 'Date'[Date] ), "Days", COUNTROWS ( T13 ) ),
    ROW ( "StartDate", "2007-12-31", "N", -1, "EndBehavior", "ENDALIGNED", "First", MINX ( T14, 'Date'[Date] ), "Last", MAXX ( T14, 'Date'[Date] ), "Days", COUNTROWS ( T14 ) ),
    ROW ( "StartDate", "2007-12-31", "N", -2, "EndBehavior", "PRECISE", "First", MINX ( T15, 'Date'[Date] ), "Last", MAXX ( T15, 'Date'[Date] ), "Days", COUNTROWS ( T15 ) ),
    ROW ( "StartDate", "2007-12-31", "N", -2, "EndBehavior", "ENDALIGNED", "First", MINX ( T16, 'Date'[Date] ), "Last", MAXX ( T16, 'Date'[Date] ), "Days", COUNTROWS ( T16 ) ),
    ROW ( "StartDate", "2007-12-31", "N", 1, "EndBehavior", "PRECISE", "First", MINX ( T17, 'Date'[Date] ), "Last", MAXX ( T17, 'Date'[Date] ), "Days", COUNTROWS ( T17 ) ),
    ROW ( "StartDate", "2007-12-31", "N", 1, "EndBehavior", "ENDALIGNED", "First", MINX ( T18, 'Date'[Date] ), "Last", MAXX ( T18, 'Date'[Date] ), "Days", COUNTROWS ( T18 ) )
  )

StartDate	N	EndBehavior	First	Last	Days
2008-03-31	-1	PRECISE	2007-12-31	2008-03-31	92
2008-03-31	-1	ENDALIGNED	2008-01-01	2008-03-31	91
2008-03-31	-2	PRECISE	2007-09-30	2008-03-31	184
2008-03-31	-2	ENDALIGNED	2007-10-01	2008-03-31	183
2008-03-31	1	PRECISE	2008-03-31	2008-06-29	91
2008-03-31	1	ENDALIGNED	2008-03-31	2008-06-29	91
2008-06-30	-1	PRECISE	2008-04-01	2008-06-30	91
2008-06-30	-1	ENDALIGNED	2008-04-01	2008-06-30	91
2008-06-30	-2	PRECISE	2007-12-31	2008-06-30	183
2008-06-30	-2	ENDALIGNED	2008-01-01	2008-06-30	182
2008-06-30	1	PRECISE	2008-06-30	2008-09-28	91
2008-06-30	1	ENDALIGNED	2008-06-30	2008-09-29	92
2007-12-31	-1	PRECISE	2007-10-01	2007-12-31	92
2007-12-31	-1	ENDALIGNED	2007-10-01	2007-12-31	92
2007-12-31	-2	PRECISE	2007-07-01	2007-12-31	184
2007-12-31	-2	ENDALIGNED	2007-07-01	2007-12-31	184
2007-12-31	1	PRECISE	2007-12-31	2008-03-30	91
2007-12-31	1	ENDALIGNED	2007-12-31	2008-03-30	91

With a positive count, the result starts on the start date. The boundary date is not included.

EVALUATE
VAR T1 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, DAY )
VAR T2 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, DAY, PRECISE )
VAR T3 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, DAY, ENDALIGNED )
VAR T4 = DATESINPERIOD ( 'Date'[Date], DATE ( 2007, 2, 28 ), 1, DAY )
VAR T5 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, MONTH )
VAR T6 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, MONTH, PRECISE )
VAR T7 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, MONTH, ENDALIGNED )
VAR T8 = DATESINPERIOD ( 'Date'[Date], DATE ( 2007, 2, 28 ), 1, MONTH )
VAR T9 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, QUARTER )
VAR T10 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, QUARTER, PRECISE )
VAR T11 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, QUARTER, ENDALIGNED )
VAR T12 = DATESINPERIOD ( 'Date'[Date], DATE ( 2007, 2, 28 ), 1, QUARTER )
VAR T13 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, YEAR )
VAR T14 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, YEAR, PRECISE )
VAR T15 = DATESINPERIOD ( Gregorian, DATE ( 2007, 2, 28 ), 1, YEAR, ENDALIGNED )
VAR T16 = DATESINPERIOD ( 'Date'[Date], DATE ( 2007, 2, 28 ), 1, YEAR )
RETURN
  UNION (
    ROW ( "Interval", "DAY", "EndBehavior", "(omitted)", "First", MINX ( T1, 'Date'[Date] ), "Last", MAXX ( T1, 'Date'[Date] ), "Days", COUNTROWS ( T1 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "PRECISE", "First", MINX ( T2, 'Date'[Date] ), "Last", MAXX ( T2, 'Date'[Date] ), "Days", COUNTROWS ( T2 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "ENDALIGNED", "First", MINX ( T3, 'Date'[Date] ), "Last", MAXX ( T3, 'Date'[Date] ), "Days", COUNTROWS ( T3 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T4, 'Date'[Date] ), "Last", MAXX ( T4, 'Date'[Date] ), "Days", COUNTROWS ( T4 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "(omitted)", "First", MINX ( T5, 'Date'[Date] ), "Last", MAXX ( T5, 'Date'[Date] ), "Days", COUNTROWS ( T5 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "PRECISE", "First", MINX ( T6, 'Date'[Date] ), "Last", MAXX ( T6, 'Date'[Date] ), "Days", COUNTROWS ( T6 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "ENDALIGNED", "First", MINX ( T7, 'Date'[Date] ), "Last", MAXX ( T7, 'Date'[Date] ), "Days", COUNTROWS ( T7 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T8, 'Date'[Date] ), "Last", MAXX ( T8, 'Date'[Date] ), "Days", COUNTROWS ( T8 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "(omitted)", "First", MINX ( T9, 'Date'[Date] ), "Last", MAXX ( T9, 'Date'[Date] ), "Days", COUNTROWS ( T9 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "PRECISE", "First", MINX ( T10, 'Date'[Date] ), "Last", MAXX ( T10, 'Date'[Date] ), "Days", COUNTROWS ( T10 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "ENDALIGNED", "First", MINX ( T11, 'Date'[Date] ), "Last", MAXX ( T11, 'Date'[Date] ), "Days", COUNTROWS ( T11 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T12, 'Date'[Date] ), "Last", MAXX ( T12, 'Date'[Date] ), "Days", COUNTROWS ( T12 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "(omitted)", "First", MINX ( T13, 'Date'[Date] ), "Last", MAXX ( T13, 'Date'[Date] ), "Days", COUNTROWS ( T13 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "PRECISE", "First", MINX ( T14, 'Date'[Date] ), "Last", MAXX ( T14, 'Date'[Date] ), "Days", COUNTROWS ( T14 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "ENDALIGNED", "First", MINX ( T15, 'Date'[Date] ), "Last", MAXX ( T15, 'Date'[Date] ), "Days", COUNTROWS ( T15 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T16, 'Date'[Date] ), "Last", MAXX ( T16, 'Date'[Date] ), "Days", COUNTROWS ( T16 ) )
  )

Interval	EndBehavior	First	Last	Days
DAY	(omitted)	2007-02-28	2007-02-28	1
DAY	PRECISE	2007-02-28	2007-02-28	1
DAY	ENDALIGNED	2007-02-28	2007-02-28	1
DAY	classic ‘Date'[Date]	2007-02-28	2007-02-28	1
MONTH	(omitted)	2007-02-28	2007-03-27	28
MONTH	PRECISE	2007-02-28	2007-03-27	28
MONTH	ENDALIGNED	2007-02-28	2007-03-30	31
MONTH	classic ‘Date'[Date]	2007-02-28	2007-03-30	31
QUARTER	(omitted)	2007-02-28	2007-05-28	90
QUARTER	PRECISE	2007-02-28	2007-05-28	90
QUARTER	ENDALIGNED	2007-02-28	2007-05-28	90
QUARTER	classic ‘Date'[Date]	2007-02-28	2007-05-30	92
YEAR	(omitted)	2007-02-28	2008-02-27	365
YEAR	PRECISE	2007-02-28	2008-02-27	365
YEAR	ENDALIGNED	2007-02-28	2008-02-27	365
YEAR	classic ‘Date'[Date]	2007-02-28	2008-02-28	366

When the start date is in the middle of a month, PRECISE and ENDALIGNED return the same dates.

EVALUATE
VAR T1 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, DAY )
VAR T2 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, DAY, PRECISE )
VAR T3 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, DAY, ENDALIGNED )
VAR T4 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 1, 15 ), -1, DAY )
VAR T5 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, MONTH )
VAR T6 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, MONTH, PRECISE )
VAR T7 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, MONTH, ENDALIGNED )
VAR T8 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 1, 15 ), -1, MONTH )
VAR T9 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, QUARTER )
VAR T10 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, QUARTER, PRECISE )
VAR T11 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, QUARTER, ENDALIGNED )
VAR T12 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 1, 15 ), -1, QUARTER )
VAR T13 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, YEAR )
VAR T14 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, YEAR, PRECISE )
VAR T15 = DATESINPERIOD ( Gregorian, DATE ( 2008, 1, 15 ), -1, YEAR, ENDALIGNED )
VAR T16 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 1, 15 ), -1, YEAR )
RETURN
  UNION (
    ROW ( "Interval", "DAY", "EndBehavior", "(omitted)", "First", MINX ( T1, 'Date'[Date] ), "Last", MAXX ( T1, 'Date'[Date] ), "Days", COUNTROWS ( T1 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "PRECISE", "First", MINX ( T2, 'Date'[Date] ), "Last", MAXX ( T2, 'Date'[Date] ), "Days", COUNTROWS ( T2 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "ENDALIGNED", "First", MINX ( T3, 'Date'[Date] ), "Last", MAXX ( T3, 'Date'[Date] ), "Days", COUNTROWS ( T3 ) ),
    ROW ( "Interval", "DAY", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T4, 'Date'[Date] ), "Last", MAXX ( T4, 'Date'[Date] ), "Days", COUNTROWS ( T4 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "(omitted)", "First", MINX ( T5, 'Date'[Date] ), "Last", MAXX ( T5, 'Date'[Date] ), "Days", COUNTROWS ( T5 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "PRECISE", "First", MINX ( T6, 'Date'[Date] ), "Last", MAXX ( T6, 'Date'[Date] ), "Days", COUNTROWS ( T6 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "ENDALIGNED", "First", MINX ( T7, 'Date'[Date] ), "Last", MAXX ( T7, 'Date'[Date] ), "Days", COUNTROWS ( T7 ) ),
    ROW ( "Interval", "MONTH", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T8, 'Date'[Date] ), "Last", MAXX ( T8, 'Date'[Date] ), "Days", COUNTROWS ( T8 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "(omitted)", "First", MINX ( T9, 'Date'[Date] ), "Last", MAXX ( T9, 'Date'[Date] ), "Days", COUNTROWS ( T9 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "PRECISE", "First", MINX ( T10, 'Date'[Date] ), "Last", MAXX ( T10, 'Date'[Date] ), "Days", COUNTROWS ( T10 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "ENDALIGNED", "First", MINX ( T11, 'Date'[Date] ), "Last", MAXX ( T11, 'Date'[Date] ), "Days", COUNTROWS ( T11 ) ),
    ROW ( "Interval", "QUARTER", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T12, 'Date'[Date] ), "Last", MAXX ( T12, 'Date'[Date] ), "Days", COUNTROWS ( T12 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "(omitted)", "First", MINX ( T13, 'Date'[Date] ), "Last", MAXX ( T13, 'Date'[Date] ), "Days", COUNTROWS ( T13 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "PRECISE", "First", MINX ( T14, 'Date'[Date] ), "Last", MAXX ( T14, 'Date'[Date] ), "Days", COUNTROWS ( T14 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "ENDALIGNED", "First", MINX ( T15, 'Date'[Date] ), "Last", MAXX ( T15, 'Date'[Date] ), "Days", COUNTROWS ( T15 ) ),
    ROW ( "Interval", "YEAR", "EndBehavior", "classic 'Date'[Date]", "First", MINX ( T16, 'Date'[Date] ), "Last", MAXX ( T16, 'Date'[Date] ), "Days", COUNTROWS ( T16 ) )
  )

Interval	EndBehavior	First	Last	Days
DAY	(omitted)	2008-01-15	2008-01-15	1
DAY	PRECISE	2008-01-15	2008-01-15	1
DAY	ENDALIGNED	2008-01-15	2008-01-15	1
DAY	classic ‘Date'[Date]	2008-01-15	2008-01-15	1
MONTH	(omitted)	2007-12-16	2008-01-15	31
MONTH	PRECISE	2007-12-16	2008-01-15	31
MONTH	ENDALIGNED	2007-12-16	2008-01-15	31
MONTH	classic ‘Date'[Date]	2007-12-16	2008-01-15	31
QUARTER	(omitted)	2007-10-16	2008-01-15	92
QUARTER	PRECISE	2007-10-16	2008-01-15	92
QUARTER	ENDALIGNED	2007-10-16	2008-01-15	92
QUARTER	classic ‘Date'[Date]	2007-10-16	2008-01-15	92
YEAR	(omitted)	2007-01-16	2008-01-15	365
YEAR	PRECISE	2007-01-16	2008-01-15	365
YEAR	ENDALIGNED	2007-01-16	2008-01-15	365
YEAR	classic ‘Date'[Date]	2007-01-16	2008-01-15	365

The following query compares the Gregorian and the Fiscal calendar. The fiscal year starts on July 1.

EVALUATE
VAR T1 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -1, YEAR, PRECISE )
VAR T2 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -1, YEAR, ENDALIGNED )
VAR T3 = DATESINPERIOD ( Fiscal, DATE ( 2008, 6, 30 ), -1, YEAR, PRECISE )
VAR T4 = DATESINPERIOD ( Fiscal, DATE ( 2008, 6, 30 ), -1, YEAR, ENDALIGNED )
VAR T5 = DATESINPERIOD ( Gregorian, DATE ( 2008, 12, 31 ), -1, YEAR, PRECISE )
VAR T6 = DATESINPERIOD ( Gregorian, DATE ( 2008, 12, 31 ), -1, YEAR, ENDALIGNED )
VAR T7 = DATESINPERIOD ( Fiscal, DATE ( 2008, 12, 31 ), -1, YEAR, PRECISE )
VAR T8 = DATESINPERIOD ( Fiscal, DATE ( 2008, 12, 31 ), -1, YEAR, ENDALIGNED )
VAR T9 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, YEAR, PRECISE )
VAR T10 = DATESINPERIOD ( Gregorian, DATE ( 2008, 2, 29 ), -1, YEAR, ENDALIGNED )
VAR T11 = DATESINPERIOD ( Fiscal, DATE ( 2008, 2, 29 ), -1, YEAR, PRECISE )
VAR T12 = DATESINPERIOD ( Fiscal, DATE ( 2008, 2, 29 ), -1, YEAR, ENDALIGNED )
VAR T13 = DATESINPERIOD ( Gregorian, DATE ( 2008, 12, 31 ), -1, QUARTER, PRECISE )
VAR T14 = DATESINPERIOD ( Gregorian, DATE ( 2008, 12, 31 ), -1, QUARTER, ENDALIGNED )
VAR T15 = DATESINPERIOD ( Fiscal, DATE ( 2008, 12, 31 ), -1, QUARTER, PRECISE )
VAR T16 = DATESINPERIOD ( Fiscal, DATE ( 2008, 12, 31 ), -1, QUARTER, ENDALIGNED )
VAR T17 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, QUARTER, PRECISE )
VAR T18 = DATESINPERIOD ( Gregorian, DATE ( 2008, 3, 31 ), -1, QUARTER, ENDALIGNED )
VAR T19 = DATESINPERIOD ( Fiscal, DATE ( 2008, 3, 31 ), -1, QUARTER, PRECISE )
VAR T20 = DATESINPERIOD ( Fiscal, DATE ( 2008, 3, 31 ), -1, QUARTER, ENDALIGNED )
VAR T21 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -2, QUARTER, PRECISE )
VAR T22 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), -2, QUARTER, ENDALIGNED )
VAR T23 = DATESINPERIOD ( Fiscal, DATE ( 2008, 6, 30 ), -2, QUARTER, PRECISE )
VAR T24 = DATESINPERIOD ( Fiscal, DATE ( 2008, 6, 30 ), -2, QUARTER, ENDALIGNED )
RETURN
  UNION (
    ROW ( "StartDate", "2008-06-30", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T1, 'Date'[Date] ), "Last", MAXX ( T1, 'Date'[Date] ), "Days", COUNTROWS ( T1 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T2, 'Date'[Date] ), "Last", MAXX ( T2, 'Date'[Date] ), "Days", COUNTROWS ( T2 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T3, 'Date'[Date] ), "Last", MAXX ( T3, 'Date'[Date] ), "Days", COUNTROWS ( T3 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T4, 'Date'[Date] ), "Last", MAXX ( T4, 'Date'[Date] ), "Days", COUNTROWS ( T4 ) ),
    ROW ( "StartDate", "2008-12-31", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T5, 'Date'[Date] ), "Last", MAXX ( T5, 'Date'[Date] ), "Days", COUNTROWS ( T5 ) ),
    ROW ( "StartDate", "2008-12-31", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T6, 'Date'[Date] ), "Last", MAXX ( T6, 'Date'[Date] ), "Days", COUNTROWS ( T6 ) ),
    ROW ( "StartDate", "2008-12-31", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T7, 'Date'[Date] ), "Last", MAXX ( T7, 'Date'[Date] ), "Days", COUNTROWS ( T7 ) ),
    ROW ( "StartDate", "2008-12-31", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T8, 'Date'[Date] ), "Last", MAXX ( T8, 'Date'[Date] ), "Days", COUNTROWS ( T8 ) ),
    ROW ( "StartDate", "2008-02-29", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T9, 'Date'[Date] ), "Last", MAXX ( T9, 'Date'[Date] ), "Days", COUNTROWS ( T9 ) ),
    ROW ( "StartDate", "2008-02-29", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T10, 'Date'[Date] ), "Last", MAXX ( T10, 'Date'[Date] ), "Days", COUNTROWS ( T10 ) ),
    ROW ( "StartDate", "2008-02-29", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T11, 'Date'[Date] ), "Last", MAXX ( T11, 'Date'[Date] ), "Days", COUNTROWS ( T11 ) ),
    ROW ( "StartDate", "2008-02-29", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T12, 'Date'[Date] ), "Last", MAXX ( T12, 'Date'[Date] ), "Days", COUNTROWS ( T12 ) ),
    ROW ( "StartDate", "2008-12-31", "Shift", "-1 QUARTER", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T13, 'Date'[Date] ), "Last", MAXX ( T13, 'Date'[Date] ), "Days", COUNTROWS ( T13 ) ),
    ROW ( "StartDate", "2008-12-31", "Shift", "-1 QUARTER", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T14, 'Date'[Date] ), "Last", MAXX ( T14, 'Date'[Date] ), "Days", COUNTROWS ( T14 ) ),
    ROW ( "StartDate", "2008-12-31", "Shift", "-1 QUARTER", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T15, 'Date'[Date] ), "Last", MAXX ( T15, 'Date'[Date] ), "Days", COUNTROWS ( T15 ) ),
    ROW ( "StartDate", "2008-12-31", "Shift", "-1 QUARTER", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T16, 'Date'[Date] ), "Last", MAXX ( T16, 'Date'[Date] ), "Days", COUNTROWS ( T16 ) ),
    ROW ( "StartDate", "2008-03-31", "Shift", "-1 QUARTER", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T17, 'Date'[Date] ), "Last", MAXX ( T17, 'Date'[Date] ), "Days", COUNTROWS ( T17 ) ),
    ROW ( "StartDate", "2008-03-31", "Shift", "-1 QUARTER", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T18, 'Date'[Date] ), "Last", MAXX ( T18, 'Date'[Date] ), "Days", COUNTROWS ( T18 ) ),
    ROW ( "StartDate", "2008-03-31", "Shift", "-1 QUARTER", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T19, 'Date'[Date] ), "Last", MAXX ( T19, 'Date'[Date] ), "Days", COUNTROWS ( T19 ) ),
    ROW ( "StartDate", "2008-03-31", "Shift", "-1 QUARTER", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T20, 'Date'[Date] ), "Last", MAXX ( T20, 'Date'[Date] ), "Days", COUNTROWS ( T20 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "-2 QUARTER", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T21, 'Date'[Date] ), "Last", MAXX ( T21, 'Date'[Date] ), "Days", COUNTROWS ( T21 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "-2 QUARTER", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T22, 'Date'[Date] ), "Last", MAXX ( T22, 'Date'[Date] ), "Days", COUNTROWS ( T22 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "-2 QUARTER", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T23, 'Date'[Date] ), "Last", MAXX ( T23, 'Date'[Date] ), "Days", COUNTROWS ( T23 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "-2 QUARTER", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T24, 'Date'[Date] ), "Last", MAXX ( T24, 'Date'[Date] ), "Days", COUNTROWS ( T24 ) )
  )

StartDate	Shift	Calendar	EndBehavior	First	Last	Days
2008-06-30	-1 YEAR	Gregorian	PRECISE	2007-07-02	2008-06-30	365
2008-06-30	-1 YEAR	Gregorian	ENDALIGNED	2007-07-02	2008-06-30	365
2008-06-30	-1 YEAR	Fiscal	PRECISE	2007-07-01	2008-06-30	366
2008-06-30	-1 YEAR	Fiscal	ENDALIGNED	2007-07-01	2008-06-30	366
2008-12-31	-1 YEAR	Gregorian	PRECISE	2008-01-01	2008-12-31	366
2008-12-31	-1 YEAR	Gregorian	ENDALIGNED	2008-01-01	2008-12-31	366
2008-12-31	-1 YEAR	Fiscal	PRECISE	2008-01-01	2008-12-31	366
2008-12-31	-1 YEAR	Fiscal	ENDALIGNED	2008-01-01	2008-12-31	366
2008-02-29	-1 YEAR	Gregorian	PRECISE	2007-03-02	2008-02-29	365
2008-02-29	-1 YEAR	Gregorian	ENDALIGNED	2007-03-02	2008-02-29	365
2008-02-29	-1 YEAR	Fiscal	PRECISE	2007-03-02	2008-02-29	365
2008-02-29	-1 YEAR	Fiscal	ENDALIGNED	2007-03-02	2008-02-29	365
2008-12-31	-1 QUARTER	Gregorian	PRECISE	2008-10-01	2008-12-31	92
2008-12-31	-1 QUARTER	Gregorian	ENDALIGNED	2008-10-01	2008-12-31	92
2008-12-31	-1 QUARTER	Fiscal	PRECISE	2008-10-01	2008-12-31	92
2008-12-31	-1 QUARTER	Fiscal	ENDALIGNED	2008-10-01	2008-12-31	92
2008-03-31	-1 QUARTER	Gregorian	PRECISE	2007-12-31	2008-03-31	92
2008-03-31	-1 QUARTER	Gregorian	ENDALIGNED	2008-01-01	2008-03-31	91
2008-03-31	-1 QUARTER	Fiscal	PRECISE	2007-12-31	2008-03-31	92
2008-03-31	-1 QUARTER	Fiscal	ENDALIGNED	2008-01-01	2008-03-31	91
2008-06-30	-2 QUARTER	Gregorian	PRECISE	2007-12-31	2008-06-30	183
2008-06-30	-2 QUARTER	Gregorian	ENDALIGNED	2008-01-01	2008-06-30	182
2008-06-30	-2 QUARTER	Fiscal	PRECISE	2007-12-31	2008-06-30	183
2008-06-30	-2 QUARTER	Fiscal	ENDALIGNED	2008-01-01	2008-06-30	182

June 30, 2009 is the last day of fiscal year 2009. With the Fiscal calendar, ENDALIGNED returns exactly fiscal year 2009, while PRECISE returns one more day.

EVALUATE
VAR T1 = DATESINPERIOD ( Gregorian, DATE ( 2009, 6, 30 ), -1, YEAR, PRECISE )
VAR T2 = DATESINPERIOD ( Gregorian, DATE ( 2009, 6, 30 ), -1, YEAR, ENDALIGNED )
VAR T3 = DATESINPERIOD ( Fiscal, DATE ( 2009, 6, 30 ), -1, YEAR, PRECISE )
VAR T4 = DATESINPERIOD ( Fiscal, DATE ( 2009, 6, 30 ), -1, YEAR, ENDALIGNED )
VAR T5 = DATESINPERIOD ( 'Date'[Date], DATE ( 2009, 6, 30 ), -1, YEAR )
VAR T6 = DATESINPERIOD ( Gregorian, DATE ( 2009, 6, 30 ), -2, YEAR, PRECISE )
VAR T7 = DATESINPERIOD ( Gregorian, DATE ( 2009, 6, 30 ), -2, YEAR, ENDALIGNED )
VAR T8 = DATESINPERIOD ( Fiscal, DATE ( 2009, 6, 30 ), -2, YEAR, PRECISE )
VAR T9 = DATESINPERIOD ( Fiscal, DATE ( 2009, 6, 30 ), -2, YEAR, ENDALIGNED )
VAR T10 = DATESINPERIOD ( 'Date'[Date], DATE ( 2009, 6, 30 ), -2, YEAR )
VAR T11 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), 1, YEAR, PRECISE )
VAR T12 = DATESINPERIOD ( Gregorian, DATE ( 2008, 6, 30 ), 1, YEAR, ENDALIGNED )
VAR T13 = DATESINPERIOD ( Fiscal, DATE ( 2008, 6, 30 ), 1, YEAR, PRECISE )
VAR T14 = DATESINPERIOD ( Fiscal, DATE ( 2008, 6, 30 ), 1, YEAR, ENDALIGNED )
VAR T15 = DATESINPERIOD ( 'Date'[Date], DATE ( 2008, 6, 30 ), 1, YEAR )
VAR T16 = DATESINPERIOD ( Gregorian, DATE ( 2009, 3, 31 ), -1, YEAR, PRECISE )
VAR T17 = DATESINPERIOD ( Gregorian, DATE ( 2009, 3, 31 ), -1, YEAR, ENDALIGNED )
VAR T18 = DATESINPERIOD ( Fiscal, DATE ( 2009, 3, 31 ), -1, YEAR, PRECISE )
VAR T19 = DATESINPERIOD ( Fiscal, DATE ( 2009, 3, 31 ), -1, YEAR, ENDALIGNED )
VAR T20 = DATESINPERIOD ( 'Date'[Date], DATE ( 2009, 3, 31 ), -1, YEAR )
RETURN
  UNION (
    ROW ( "StartDate", "2009-06-30", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T1, 'Date'[Date] ), "Last", MAXX ( T1, 'Date'[Date] ), "Days", COUNTROWS ( T1 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T2, 'Date'[Date] ), "Last", MAXX ( T2, 'Date'[Date] ), "Days", COUNTROWS ( T2 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T3, 'Date'[Date] ), "Last", MAXX ( T3, 'Date'[Date] ), "Days", COUNTROWS ( T3 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T4, 'Date'[Date] ), "Last", MAXX ( T4, 'Date'[Date] ), "Days", COUNTROWS ( T4 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-1 YEAR", "Calendar", "classic 'Date'[Date]", "EndBehavior", "-", "First", MINX ( T5, 'Date'[Date] ), "Last", MAXX ( T5, 'Date'[Date] ), "Days", COUNTROWS ( T5 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-2 YEAR", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T6, 'Date'[Date] ), "Last", MAXX ( T6, 'Date'[Date] ), "Days", COUNTROWS ( T6 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-2 YEAR", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T7, 'Date'[Date] ), "Last", MAXX ( T7, 'Date'[Date] ), "Days", COUNTROWS ( T7 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-2 YEAR", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T8, 'Date'[Date] ), "Last", MAXX ( T8, 'Date'[Date] ), "Days", COUNTROWS ( T8 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-2 YEAR", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T9, 'Date'[Date] ), "Last", MAXX ( T9, 'Date'[Date] ), "Days", COUNTROWS ( T9 ) ),
    ROW ( "StartDate", "2009-06-30", "Shift", "-2 YEAR", "Calendar", "classic 'Date'[Date]", "EndBehavior", "-", "First", MINX ( T10, 'Date'[Date] ), "Last", MAXX ( T10, 'Date'[Date] ), "Days", COUNTROWS ( T10 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "+1 YEAR", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T11, 'Date'[Date] ), "Last", MAXX ( T11, 'Date'[Date] ), "Days", COUNTROWS ( T11 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "+1 YEAR", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T12, 'Date'[Date] ), "Last", MAXX ( T12, 'Date'[Date] ), "Days", COUNTROWS ( T12 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "+1 YEAR", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T13, 'Date'[Date] ), "Last", MAXX ( T13, 'Date'[Date] ), "Days", COUNTROWS ( T13 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "+1 YEAR", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T14, 'Date'[Date] ), "Last", MAXX ( T14, 'Date'[Date] ), "Days", COUNTROWS ( T14 ) ),
    ROW ( "StartDate", "2008-06-30", "Shift", "+1 YEAR", "Calendar", "classic 'Date'[Date]", "EndBehavior", "-", "First", MINX ( T15, 'Date'[Date] ), "Last", MAXX ( T15, 'Date'[Date] ), "Days", COUNTROWS ( T15 ) ),
    ROW ( "StartDate", "2009-03-31", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "PRECISE", "First", MINX ( T16, 'Date'[Date] ), "Last", MAXX ( T16, 'Date'[Date] ), "Days", COUNTROWS ( T16 ) ),
    ROW ( "StartDate", "2009-03-31", "Shift", "-1 YEAR", "Calendar", "Gregorian", "EndBehavior", "ENDALIGNED", "First", MINX ( T17, 'Date'[Date] ), "Last", MAXX ( T17, 'Date'[Date] ), "Days", COUNTROWS ( T17 ) ),
    ROW ( "StartDate", "2009-03-31", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "PRECISE", "First", MINX ( T18, 'Date'[Date] ), "Last", MAXX ( T18, 'Date'[Date] ), "Days", COUNTROWS ( T18 ) ),
    ROW ( "StartDate", "2009-03-31", "Shift", "-1 YEAR", "Calendar", "Fiscal", "EndBehavior", "ENDALIGNED", "First", MINX ( T19, 'Date'[Date] ), "Last", MAXX ( T19, 'Date'[Date] ), "Days", COUNTROWS ( T19 ) ),
    ROW ( "StartDate", "2009-03-31", "Shift", "-1 YEAR", "Calendar", "classic 'Date'[Date]", "EndBehavior", "-", "First", MINX ( T20, 'Date'[Date] ), "Last", MAXX ( T20, 'Date'[Date] ), "Days", COUNTROWS ( T20 ) )
  )

StartDate	Shift	Calendar	EndBehavior	First	Last	Days
2009-06-30	-1 YEAR	Gregorian	PRECISE	2008-06-30	2009-06-30	366
2009-06-30	-1 YEAR	Gregorian	ENDALIGNED	2008-06-30	2009-06-30	366
2009-06-30	-1 YEAR	Fiscal	PRECISE	2008-06-30	2009-06-30	366
2009-06-30	-1 YEAR	Fiscal	ENDALIGNED	2008-07-01	2009-06-30	365
2009-06-30	-1 YEAR	classic ‘Date'[Date]	–	2008-07-01	2009-06-30	365
2009-06-30	-2 YEAR	Gregorian	PRECISE	2007-07-01	2009-06-30	731
2009-06-30	-2 YEAR	Gregorian	ENDALIGNED	2007-07-01	2009-06-30	731
2009-06-30	-2 YEAR	Fiscal	PRECISE	2007-07-01	2009-06-30	731
2009-06-30	-2 YEAR	Fiscal	ENDALIGNED	2007-07-01	2009-06-30	731
2009-06-30	-2 YEAR	classic ‘Date'[Date]	–	2007-07-01	2009-06-30	731
2008-06-30	+1 YEAR	Gregorian	PRECISE	2008-06-30	2009-06-30	366
2008-06-30	+1 YEAR	Gregorian	ENDALIGNED	2008-06-30	2009-06-30	366
2008-06-30	+1 YEAR	Fiscal	PRECISE	2008-06-30	2009-06-29	365
2008-06-30	+1 YEAR	Fiscal	ENDALIGNED	2008-06-30	2009-06-29	365
2008-06-30	+1 YEAR	classic ‘Date'[Date]	–	2008-06-30	2009-06-29	365
2009-03-31	-1 YEAR	Gregorian	PRECISE	2008-03-31	2009-03-31	366
2009-03-31	-1 YEAR	Gregorian	ENDALIGNED	2008-03-31	2009-03-31	366
2009-03-31	-1 YEAR	Fiscal	PRECISE	2008-03-31	2009-03-31	366
2009-03-31	-1 YEAR	Fiscal	ENDALIGNED	2008-03-31	2009-03-31	366
2009-03-31	-1 YEAR	classic ‘Date'[Date]	–	2008-04-01	2009-03-31	365

Learn more about DATESINPERIOD in the following articles:

Yearly Customer Historical Sales in DAX
With DAX you can calculate the sales of the first, second and third year of a new customer without any ETL. In this article you see how to implement this calculation with good performance. » Read more
Show previous 6 months of data from single slicer selection
In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months. » Read more
Rolling 12 Months Average in DAX
Rolling averages over time (a.k.a. moving averages or running averages) are useful to smoothen chart lines and to make trends more evident. This article shows how to compute a rolling average over 12 months, in DAX. » Read more
Blank in date columns and DAX time intelligence functions
This article explores the implications of having blank values in date columns and provides the best practices for managing them in DAX calculations and Power BI reports. » Read more
Understanding DATEADD parameters with calendar-based time intelligence
The new calendar-based time intelligence functions offer greater flexibility than the classic time intelligence functions. This article describes the DATEADD parameters for controlling different granularity shifts. » Read more
Using REMOVEFILTERS in DAX user-defined functions
In this article, we implement a function that removes filter-keep column filters from a calendar, using REMOVEFILTERS as the return value of the function. » Read more

Last update: Oct 28, 2026 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Bernat Agullo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/datesinperiod-function-dax

Compatibility

Measures

Calculated columns

Power BI
v13.0.1700.1022 →
v17.0.93.23
Current release
Excel
v11.0.9165.1186 →
v16.0.9.17
- Excel 2016
- Excel 2019
- Excel Microsoft 365
SSAS Tabular
v10.50.1600.1 →
v17.0.25.223
- SSAS 2012
- SSAS 2014
- SSAS 2016
- SSAS 2017
- SSAS 2019
- SSAS 2025
- SSAS Tabular
Azure AS
v14.0.1.501 →
v17.0.63.19
Current release
SSDT
v14.0.1.432 →
v16.0.70.21
Current release

» Show verified builds

First release

Before 2017-01-01

DATESINPERIOD DAX Function (Time Intelligence)

Syntax

Return values

Notes

Remarks

Examples

Related articles

Context Transition

Row Context

Passed by Expression

Iterator

Not recommended

Not recommended

Deprecated

Volatile

Deprecated

DirectQuery compatibility

Contribute