Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |