CALENDARAUTO

Updated on
Rick de Groot

CALENDARAUTO is a DAX function that returns a table with one column of dates calculated automatically from the model.

Syntax

CALENDARAUTO( FiscalYearEndMonth )
Argument Properties Description
FiscalYearEndMonth Optional An integer from 1 to 12 representing the end month of fiscal year.

Return Values

Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is calculated automatically based on data in the model.

Remarks

  • The date range is calculated as follows:

    • The earliest date in the model which is not in a calculated column or calculated table is taken as the MinDate.
    • The latest date in the model which is not in a calculated column or calculated table is taken as the MaxDate.
    • The date range returned is dates between the beginning of the fiscal year associated with MinDate and the end of the fiscal year associated with MaxDate.

  • An error is returned if the model does not contain any datetime values which are not in calculated columns or calculated tables.

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

Example

In this example, the MinDate and MaxDate in the data model are July 1, 2010 and June 30, 2011.

CALENDARAUTO() will return all dates between January 1, 2010 and December 31, 2011.

CALENDARAUTO(3) will return all dates between April 1, 2010 and March 31, 2012.

Other functions related to CALENDARAUTO are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/calendarauto-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy