Insert a dates between list of dates in power quary

[Anonymous]

hi guys, 

i am newbie in power bi and i have quation..

i have a big list of dates between mondey to friday and i need to "open" the list and insert the dates of Saturday and Sunday every week and then insert the value of the last friday in reapet 

Btw everything have to be in power quary only without using Dax

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can follow the steps below to get it in Power Query Editor, please see the attachment for the details.

1. Create a date table with the full dates(include Saturday and Sunday) in Power Query Editor

2. Merge the queries using Right Outter join

In addition, you can also refer the following links to get it:

1. Get the column [End Date]

Refer to Previous Row and Next Row in Power Query

2. Fill the dates

How to add rows for dates between start and end dates in Power BI date range data

How to Fill Dates Between Start Date and End Date in Power BI (Power Query)

Best Regards

[amitchandak]

@Anonymous, The information you have provided is not making the problem clear to me. Can you please explain with an example?
refer if this can help

https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
Appreciate your Kudos.