Creating date column from dates between two columns - Query

[Anonymous]

Hey i am trying to connect calculated time table and data from this data set. (down) But to correct reporting i need to create list of days between start and end in one column with all other columns in same state as they are now.

My idea is to do it with custom function. Maybe with loop cykle but i really dont know how. Can someone please help me with this?

[artemus · Accepted solution]

You can add a custom column with:

List.Dates([start_date], Duration.Days([end_date] - [start_date]) + 1, #duration(1, 0, 0, 0))

Then, expand the custom column.