Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Solved! Go to 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! 🤠
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! 🤠
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |