Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

calendarauto function help

Hi Team   amitchandak    I was trying to understand the calendarauto() functions and used the function in power bi desktop but the dates produced seems to be wrong   measure=calendarauto(6)-->...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    As is mentioned in the document , the parameter in 'CALENDARAUTO' means the end month of the fiscal year.

    CALENDARAUTO([fiscal_year_end_month])
    Term Definition
    fiscal_year_end_month Any DAX expression that returns an integer from 1 to 12. If omitted, defaults to the value specified in the calendar table template for the current user, if present; otherwise, defaults to 12.

     

    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.

     

    Example:

     

    So when the parameter is set as 6, the end month of fiscal year is June. The beginning of the fiscal year associated with MinDate is July 1st of 2017. The end of the fiscal year associated with MaxDate is June 30 of 2021.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

 

As is mentioned in the document , the parameter in 'CALENDARAUTO' means the end month of the fiscal year.

CALENDARAUTO([fiscal_year_end_month])
Term Definition
fiscal_year_end_month Any DAX expression that returns an integer from 1 to 12. If omitted, defaults to the value specified in the calendar table template for the current user, if present; otherwise, defaults to 12.

 

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.

 

Example:

 

So when the parameter is set as 6, the end month of fiscal year is June. The beginning of the fiscal year associated with MinDate is July 1st of 2017. The end of the fiscal year associated with MaxDate is June 30 of 2021.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.