Forum Discussion
calendarauto returns nothing
jsteffe I can't explain it. Can you share your PBIX file or a stripped down version of it just to see if it is a version or regional language setting issue? You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
I just found my error : I put my formula in a new colum rather than writting it directly in the NEW TABLE.
Sorry for this. I feel so stupid and thanks for your help Greg ...
- jsteffe Don't feel stupid! Stuff like that happens. Man, you had me going though!! 🙂
Hi, jsteffe
If you do not have a Date table in your data source, you can create such a table directly in the data model by adding calculated columns to a table built by using either CALENDAR or CALENDARAUTO.
CALENDARAUTO automatically finds the minimum and maximum year of all the date columns included across the whole data model, and generates all the dates included between these years. You can specify a month number as an argument to CALENDARAUTO. If provided, it generates dates from the first day of the following months to the last day of the month indicated as an argument. This is useful when you have a fiscal year that ends in a month other than December.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
