Forum Discussion
Date column Convert new column Week basics
I am trying to Create a new column called week based on below logic
- If day part of lead_date <=7 -> Wk1
- If day part of lead_date between 8 to 14 -> Wk2
- If day part of lead_date between 15 to 21 -> Wk3
- If day part of lead_date>21 -> Wk4
Sample Data:
trail_id lead_date
626238 01-08-2021
626231 02-08-2021
626232 03-08-2021
646067 04-08-2021
644770 05-08-2021
--
--
643468 31-08-2021
My Measure :
WEEK = "Wk"& 1 + WEEKNUM ('Sheet1'[lead_date] ) -WEEKNUM( STARTOFMONTH ('Sheet1'[lead_date]))
looking for support .. thanks in advance
Hi!
You can try create calc column
SWITHC(TRUE(),
DAY([lead_date]) <= 7, "Week 1",
DAY([lead_date]) <= 14, "Week 2",
DAY([lead_date]) <= 21, "Week 3",
"Week 4"
)
