Forum Discussion
calendarauto function help
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.
Anonymous , do you have any date in any of the date column from 1-Jul-2017 to 30-jun-2018, That will force it to start from 1-Jul-2017
amitchandak no i do not have it ...it has dates only from Jan -dec 2018, Jan -dec 2019, Jan -dec 2020.
How come iam getting 2017?? is it because im forcing calendar to start from July 2018 though there is data for jan 2018???
Regards,
Husna