The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
i want to convert a numeric column containing difference between 2 dates like (0,1,2,3..... so on) into 3 groups --> same_day, d+1 and >1 day
How to convert the numeric column and categorize them into 3 groups?
days between (difference b/w 2 dates)| ---> | 3 categories
0 same day
1 D+1 day
2 >1 day
3 >1 day
....
6 >1 day
Solved! Go to Solution.
hi @Bu__
try like:
hi @Bu__
try like:
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |