Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
how to create Custom column based on same column values using between operator ??
example:i have a column with values range from 0 to 10..i wanted to create custom column based on the condition.(ie).0-5 as custom column and 5 -10 as other custom column..
Solved! Go to Solution.
If I understand this right you may be overthinking this.
Just a simple if statement would do.
You may have to change this a bit but here it is depending on where you want the 5 included
Custom Column = IF ( Table[Column] < 6, "0-5", "6-10" )
Good Luck!
I would do a conditional column in query editor based on the logic above. If less than or equal to 6 then... etc.
I would do a conditional column in query editor based on the logic above. If less than or equal to 6 then... etc.
Yes that works too! In fact that’s what I would do too!
If I understand this right you may be overthinking this.
Just a simple if statement would do.
You may have to change this a bit but here it is depending on where you want the 5 included
Custom Column = IF ( Table[Column] < 6, "0-5", "6-10" )
Good Luck!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |