Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
@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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |