Forum Discussion
Split a single row into multiple rows
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
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.
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