Conditional column-Power Query

[rajendraongole1]

Hi 

I have a values in a column between 0.01 to 0.98 where i have to consider the value should be 1 between this range.

reamining values i have to maintain as it is. like null and other values should nt disturb,

Tried with List.contains function with list of values but not working properly.

Kindly suggest if there is any approach to write condition between the range from 0.01 to 0.98 should treat as 1 .

[amitchandak · Accepted solution]

@rajendraongole1 , hope is is a numeric column

if [column] >= 0.01 and [column] <= 0.98 then 1 else null