Forum Discussion

jsteffe's avatar
jsteffe
Icon for Helper III rankHelper 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 was date).
 
 
Thanks for your help.

8 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

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

     

    Calendar = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
    • jsteffe's avatar
      jsteffe
      Icon for Helper III rankHelper III

      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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

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

         

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