Reverting a date into the first of every single week

[Anonymous]

Hi, as you can see from the screenshot below, I have a "SCHEDULED_FROM" column, is it possible I could create a new column which only displays the first day (Monday) of that week? i.e. if the date is 27/10/2020, could i convert it to 26/10/2020.

[V-pazhen-msft · Accepted solution]

@Anonymous 

New Column = CALCULATE(MAX([SCHEDULED_FROM]),FILTER('Table',WEEKDAY([SCHEDULED_FROM],2)=1 && 'Table'[SCHEDULED_FROM]<=EARLIER([SCHEDULED_FROM])))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[pranit828]

HI @Anonymous 

I would use the below code

'Table'[SCHEDULED_FROM] - WEEKDAY('Table'[SCHEDULED_FROM],2)+1

 

[BA_Pete]

Hi @Anonymous ,

Check out THIS THREAD.

@TomMartens gives a perfect walkthrough for DAX.

Alternatively, you can use the Date.StartOfWeek() function in Power Query, where the second argument is where you would specify that Monday was your start-of-week day.

Pete