List the Date as raw for each start of week dates

[Zack92]

Hello, 

I have a bunch of start week dates, I want to list all the dates for each start of the week as raw. Can anybody please let me know how I can achieve this?

For Example,

Sample File 
https://drive.google.com/file/d/14objFl9oSKUW9skh5SqKt1ynROSfq7d5/view?usp=sharing 

Thank you so much 

[Zack92]

@Daniel29195  Thank you so much for the quick response and help. 

[Daniel29195 · Accepted solution]

Hello @Zack92

1.go to power query : 

2.create a dimdate table :   -- https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query  

NB :  your weeks are end of week as per the dimdate table. 

you will have start of week as column . 

3. use merge function to merge your table with dimdate table as follow : 

4 . merge on the column date from your table with end of week from dimdate table .

5.expand the new added column to the table 

you will have the expanded version as you like .

NB : 
base on my dimdate table , i merged on the end of week, 

for your question, you need to have a custom date table where start of week  12/31/2023 has dates list : 

1/1/2024 ,  1/2/2024 , 1/3/2024 ,  1/4/2024 , 1/5/2024 ,  1/6/2024

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠