Custom column based on same column values using between operator

[Gokul]

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.. 

[v-yuta-msft]

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