Forum Discussion
How to create rows based on dates on seperate rows?
Hi all, I'm trying to create an inventory table. Currently i have this: user date Key John 1/2/2016 5 Jane 3/2/2016 5 John 6/2/2016 5 Mike 8/2/2016 5 ...
Hey,
the little secret is M function List.Dates() ...
Here you will find a little pbix file
In the Query Editor I added a custom column using this function
List.Dates([Date],[Index], #duration(1,0,0,0))
After expanding the column to new rows you will receive what you are looking for
Hope this gets you started
Regards