Split a single row into multiple rows

[pcav]

I would be grateful for any assistance with my latest challenge in PowerBI/PowerQuery

I have a table that records engineer recurring activities on a single row with a start and end date .....

I need to extrapolate these to another table with one row per engineer per day per activity, like so ...

I've been struggling with this for days ...

Thanks

[elJukes]

Hi Pcav

You could try adding an extra column in the Query Editor using this formulae:

Table.AddColumn(#"Previous Step","Date", each {Number.From([StartDate])..Number.From([EndDate])})

That will create a list of all the dates between your start and end (inclusive). You can then expand the column out using the little icon in it's header and it'll create a row per person per day. Once you've expended the Date column out you'll need to format it as a date otherwise it'll look like a bunch of numbers - those numbers are actually date codes.

[pcav · Accepted solution]

Thank for the reply.  In the end I actualy resolved this ... I discovered CROSSJOIN and CALENDER and used these to dynamically create the new table in DAX