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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

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
    Helper III
    6 years ago

    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
      Community Champion
      6 years ago

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

       

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

      • jsteffe's avatar
        jsteffe
        Helper III
        6 years ago

        Same result : blank table ...

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