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..
Hi Gokul,
As a general solution, you can use if else statement below in power query to achieve this:
= if condition1 then result1 else result2
In addtion, if you have other requirement, please share more details about your logic and expected result.
Regards,
Jimmy Tao
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |