Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |