Forum Discussion
Create a dynamic Column Title name for an existing static column based on filter on date column
Is it possible to shape your data in Power Query so it's daily rather than weekly? I don't think a dynamic Column Title name is possible, and I expect moving to a table which is just WeekStartDate/Day/Comment/DayDate will remove the need for this.
There's almost certainly better ways of doing this in M, but what I'm thinking of is you load the data in 7 times. First time keep StartDate/Day1/Comment1, add acolumn Called DayDate which is just equal to StartDate and rename Day1->Day & Comment1->Comment. Second time keep StartDate/Day2/Comment2, add acolumn Called DayDate which is just equal to StartDate + 1 day and rename Day2->Day & Comment2->Comment. Third time keep StartDate/Day3/Comment3, add acolumn Called DayDate which is just equal to StartDate + 2 days and rename Day3->Day & Comment3->Comment. Repeat for each day of the week. Append them all together.