Forum Discussion

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.

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.

Super User

5 years ago

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]