Forum Discussion

jsteffe's avatar
jsteffe
Helper III
6 years ago

calendarauto returns nothing

I use this formula to automatically create a calendar but nothing happens. I get no date. Calendar = CALENDARAUTO()   In my model I get a table with a field which is a date (I checked the format ...
Need Help
jsteffe's avatar
jsteffe
Helper III
6 years ago

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 ...

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

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.