Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi there,
I am looking to create weekly buckets to sort data within a date column, so that the week starts on a Saturday and ends on a Friday. For example: Saturday, October 1, 2022 through Friday, October 7, 2022 should display October 1, 2022. And Saturday, October 8, 2022 through Friday, October 14, 2022 should display October 8, 2022.
I used the following formula: 'Date'[Date] - WEEKDAY('Date'[Date], 2) - 1, but this did not have the desired outcome because the column is still using Monday as the start day for each week. Additionally, I tried changing the arguements to the WEEDAY function, but it appears I am only allowed to enter in 1 through 3.
Any help with with this would be greatly appreciated.
Solved! Go to Solution.
Thanks for the clarification @Greg_Deckler ! I was able to get the same results using "+1" at the end of formula instead of "-1"
'Date'[Date] - WEEKDAY('Date'[Date], 16) - 1
Hi @Greg_Deckler ,
Thank you for the prompt reply! Unfortunately, the formula provided did not have the desired outcome. I was able to brute force the desired outcome using a long "if" statement.
Thanks again!
Using 16 as the second parameter of weekday returns Saturday = 1 and Friday = 7.WEEKDAY('Date'[Date], 16)
Thanks for the clarification @Greg_Deckler ! I was able to get the same results using "+1" at the end of formula instead of "-1"
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |