Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Zack92
Helper II
Helper II

List the Date as raw for each start of week dates

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,
 
Thank you so much 
 
1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

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  

Daniel29195_0-1706652070153.png

 

 

Daniel29195_3-1706652347258.png

 

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 : 

Daniel29195_2-1706652261213.png

 

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

Daniel29195_4-1706652423234.png

 

5.expand the new added column to the table 

Daniel29195_7-1706652665484.png

 

 

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! 🤠

 

 

 

 

View solution in original post

2 REPLIES 2
Zack92
Helper II
Helper II

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

Daniel29195
Super User
Super User

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  

Daniel29195_0-1706652070153.png

 

 

Daniel29195_3-1706652347258.png

 

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 : 

Daniel29195_2-1706652261213.png

 

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

Daniel29195_4-1706652423234.png

 

5.expand the new added column to the table 

Daniel29195_7-1706652665484.png

 

 

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! 🤠

 

 

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors