I'm very new to PowerQuery but have a task that makes me mad.
Imagine I have a table that possesses 3 columns: "Start Date", "End Date", and "Name". Say, this table contains information about sprints.
I need to convert this table into another one that contains only 2 columns: "Date" and "Name". So that each date within a period [StartDate...EndDate] gets a line within my second table.
|Start Date||End Date||Name|
|1 Jan 2023||5 Jan 2023||Sprint 1|
|10 Jan 2023||11 Jan 2023||Sprint 2|
|1 Jan 2023||Sprint 1|
|2 Jan 2023||Sprint 1|
|3 Jan 2023||Sprint 1|
|4 Jan 2023||Sprint 1|
|5 Jan 2023||Sprint 1|
|10 Jan 2023||Sprint 2|
|11 Jan 2023||Sprint 2|
It's clear to me that I should walk through the InputTable row by row and then fulfill the OutputTable using the row data. But... no idea how to do it in practice. Could someone help me with this?