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

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

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