calendarauto returns nothing

[jsteffe]

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 was date).

Thanks for your help.

[Greg_Deckler]

@jsteffe - That's definitely odd. You can do it the "hard" way like:

Calendar = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

[jsteffe]

I tried your formula but I get no date too.

Calendar = CALENDAR(MIN('EXP'[SM réelle]);MAX('EXP'[SM réelle]))

The data type for my date field "SM Réelle" is date ...

[Greg_Deckler]

Well, it's odd. So that returns a blank table??

What if you try date_livraison instead of SM Réelle?

[jsteffe]

Same result : blank table ...

I calculated Date_livraison from SM réelle to check if the problem comes from the name of the column ...

[Greg_Deckler]

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

[jsteffe]

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]

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.

[Greg_Deckler]

@jsteffe Don't feel stupid! Stuff like that happens. Man, you had me going though!! 🙂