Forum Discussion
Solved
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 sh...
BastiB , Power query way
Power BI - Get Dates between range using Power Query: https://youtu.be/SFEPsKfqIks
Or DAX way
amitchandak
Super User
Super UserBastiB , Power query way
Power BI - Get Dates between range using Power Query: https://youtu.be/SFEPsKfqIks
Or DAX way
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?