Dynamically generate table rows for each row

[mrasenberg]

Hi all,

Being quite new to Power Bi, I'm reaching out to this community. 

What I'm trying to achieve is to dynamically generate table rows for each date in a date range. 

The source:

Id	StartDate	EndDate	DateDifference
7069	01-11-2016	04-11-2016	3
7070	01-11-2016	04-11-2016	3
7071	31-10-2016	04-11-2016	4
7072	06-11-2016	11-11-2016	5

The result should be a row for each date between the StartDate and EndDate.

I was looking for a Power Query solution but that didn't worked out (by me). 

Anyone a hint or solution?

Thanks in advance!

Kind regards,

Maarten Rasenberg