Forum Discussion
Creating similar rows for a date period
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
BastiB , Power query way
Power BI - Get Dates between range using Power Query: https://youtu.be/SFEPsKfqIks
Or DAX way
2 Replies
- amitchandak
Super User
BastiB , Power query way
Power BI - Get Dates between range using Power Query: https://youtu.be/SFEPsKfqIks
Or DAX way
- BastiBRegular Visitor
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?