Creating similar rows for a date period

[BastiB]

Hello there,

I have rows which each contain a start and an end date. Now I want to duplicate each row for each date that lies within this date period (Like shown in the example pictures). That should result in a row for every date.

I already tried something with DATESBETWEEN, but that didn't work out. And I haven't found a suitable solution in existing threads.

Thank You!

Basti

Initial raw dataHow it should look like

[amitchandak · Accepted solution]

@BastiB , Power query way

Power BI - Get Dates between range using Power Query: https://youtu.be/SFEPsKfqIks

https://medium.com/@amitchandak/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f...

Or DAX way

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[BastiB]

Thank You @amitchandak! The DAX solution works very well for my data.

I have another question/problem: Now I would like to exclude weekends and holidays. I guess, that this is manageable via a third column and a filter. But how can I do that correctly?