Forum Discussion
Creating new table - date-table : i get different results?
¿ @Oskar
My bad partner. Completely misread the document and, as you said, modifies the start/end of the fiscal year.
If you're willing to switch from CALENDARAUTO() to something else, try this: https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-bi
This provides much more user control in creating the Date table and you can modify it as needed.
I hope it helps the mate.
Apologies again!
Theo
What, are you sure?
https://docs.microsoft.com/en-us/dax/calendarauto-function-dax
Just changing the value from 1 to 13 to get 13 years range.
The value can only be 1-12 and is based on fiscal year so picking 1 is from January and picking 3 is from March
But the documentation mention minDate and maxDate. But i dont get where that is defined.
How can my other PowerBI report have dates dating back 100 years and still just having 1 set in CALENDARAUTO.
¿ @Oskar
My bad partner. Completely misread the document and, as you said, modifies the start/end of the fiscal year.
If you're willing to switch from CALENDARAUTO() to something else, try this: https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-bi
This provides much more user control in creating the Date table and you can modify it as needed.
I hope it helps the mate.
Apologies again!
Theo