Expanding Dates - File Source

[Anonymous]

Hello all.

I am trying to transform my data source from this:

Item                        Date initiated             Date concluded

XXX                         01/01/2016               04/01/2016

YYY                         04/01/2016               05/01/2016

To this:

Item                        Date

XXX                         01/01/2016

XXX                         02/01/2016

XXX                         03/01/2016

XXX                         04/01/2016

YYY                         04/01/2016

YYY                         05/01/2016

I didn't even come close to a solution.

Any thoughts?

Thanks in advance.

[Anonymous · Accepted solution]

Solved.

http://community.powerbi.com/t5/Desktop/Loop-through-table-to-turn-one-row-into-multiple-rows/m-p/51...