Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to Create a new column called week based on below logic
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 :
looking for support .. thanks in advance
Solved! Go to 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"
)
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"
)
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |