Beginning of the Week

[Anonymous]

Hello,

I'm trying to creat a column that will contains the date of the previous monday according to my column Date.

For exemple, if i got sunday 15 october 2019 i would like to have monday 9 october 2019

If I have monday 19 october 2022 I would like to keep this date.

I tried to use a DateAdd but it only show the date contains in my column date.

I also try with a weekday, weeknum and year but I don't know how to creat a new date with those informations.

If someone can help me it would be very nice.

Thank you

[Samarth_18 · Accepted solution]

Hi @Anonymous 

You can create a column with below code:-

Last_Monday = CALENDER_TABLE[Date] - WEEKDAY(CALENDER_TABLE[Date],2)+1

Thanks,

Samarth

[Anonymous]

Thank you! 

[Greg_Deckler]

@Anonymous Try something like:

Column = 
  VAR __Date = [Date]
  VAR __MinDate = [Date] - 7
  VAR __Calendar = ADDCOLUMNS(CALENDAR(__MinDate, __Date),"__Weekday",WEEKDAY([Date],2))
  VAR __MaxMonday = MAXX(FILTER(__Calendar,[__Weekday] = 1),[Date])
RETURN
  __MaxMonday

[Anonymous]

Thank you!