Forum Discussion

925stuart's avatar
925stuart
Helper I
2 years ago
Solved

How do I convert number ranges into a text?

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!
Need Help
  • 925stuart's avatar
    925stuart
    2 years ago

    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.   

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago
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