Data Studio
6.2K members online now
6.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Week Commencing Date

Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

I need to round dates to the nearest Monday of that week, ie Wednesday 12th April 2017 would become Monday 10th April 2017.

 

Has anyone done this? I'm assuming there is a way by making the date a 'week number', week() rounding down, Round() and making it a date again? Or similar method?