Forum Discussion
Group Weekly Start on Sundays
Hi,
Is there a way to create a calculated column displaying weeks starting on sunday?
so for example, i have data from 2019-present. i would want the dates in 2020 to be displayed like "12/29, 1/5, 1/12, etc..."
I have this formula:
Start of Week test = DATEADD('Crew Productivity'[Week Start 1/1?],-1*WEEKDAY('Crew Productivity'[Week Start 1/1?])+weekday(STARTOFYEAR('Crew Productivity'[Week Start 1/1?])),DAY)
but this displays weeks starting on 1/1...
Thank you!
Sarah
Sarah
Anonymous add a column with this expression
week start date = DATEADD ( Table[Date], -WEEKDAY ( Table[Date],1 ), DAY )I would 💖 Kudos 🙂 if my solution helped. ?
2 Replies
- parry2k
Super User
Anonymous add a column with this expression
week start date = DATEADD ( Table[Date], -WEEKDAY ( Table[Date],1 ), DAY )I would 💖 Kudos 🙂 if my solution helped. ?