Forum Discussion
Solved
Have Week Start on Saturday in Date Column
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 Frida...
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) - 1Hi 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"