How do I convert number ranges into a text?

[925stuart]

Hi, 

How do I convert number ranges into a text?  E.g. 

• <1 = "Text1"
• > 0 but <11 = "Text2"
• > 10 but <21 = "Text3"
• >20 = "Text 4"

Thanks!

[925stuart · Accepted solution]

Thanks for all your suggestions!  I finally used (a Youtube solution) Switch to compare the number against a range to yield a True/False, and then assigning a Text value depending on the Binary test.   

[j_ocean]

Use a conditional column.

[wdx223_Daniel]

let
    Source = #table(1,List.Zip({{0..25}})),
    Custom1 = Table.AddColumn(Source,"Custom",each {"Text1","Text2","Text3","Text4"}{List.PositionOf({1,11,21},[Column1],1,(x,y)=>y>=x)+1})
in
    Custom1