Forum Discussion

waleed111's avatar
waleed111
Helper V
5 years ago

CALENDARAUTO function

how can i get a date column using CALENDARAUTO function, i not want getting a table from it i want column just.

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    dates=CALENDARAUTO('List View'[start date])
    • waleed111's avatar
      waleed111
      Helper V
      5 years ago

      i know that CALENDARAUTO function return table, but my question is are there a way to get a date column using it.

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        5 years ago

        waleed111 

        I don't think we can do that for a column. CALENDARAUTO() will generate the dates automatically as a table.

        Do you want to create continuous dates?

        maybe you can try create an index column in PQ first, then use the starting date +index column

        Column = DATE(2020,1,1)+tbl[Index]