Forum Discussion
Solved
Power Query. Pivoting data and creating missing dates in between start and end dates
Hi, I am building a staff utilisation dashboard. I have a dataset with projects estimated start and end date. Each project is allocated to a project manager. An assumption is that a project ma...
I have figured out how to do that by creating a "list" of a ranges of values between two dates in Power Query:
Dates = { Number.From([Start])..Number.From([End]) }
Then, I expanded the list to new rows and created duplicate lines with project id, names and hours for each day of a project.
This is very difficult to read.
Fixed the formatting. Hope it is easier to read now. Please tell me if not clear I can try to explain better what I need
I have figured out how to do that by creating a "list" of a ranges of values between two dates in Power Query:
Dates = { Number.From([Start])..Number.From([End]) }
Then, I expanded the list to new rows and created duplicate lines with project id, names and hours for each day of a project.