Date column Convert new column Week basics

[Anonymous]

I am trying to Create a  new column called week based on below logic

1. If day part of lead_date <=7 -> Wk1
2. If day part of lead_date  between 8 to 14 -> Wk2
3. If day part of lead_date between 15 to 21 -> Wk3
4. 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

[technolog · Accepted solution]

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"

)

[Anonymous]

@technolog  thank you  its worked