Forum Discussion

BJE's avatar
BJE
Helper I
6 years ago
Solved

Sorting a visual using text-based ranges

I have a table that I has a column recording the FTE for each company in the list. I have created an additional column that has created FTE ranges, i.e.: 0-4 5-9 10-24 25-49 50-99 100-149 150-...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    or better could use " " (2 blanks or 1 blank depending the number of digits) instead "0"

     

ziying35's avatar
ziying35
Impactful Individual
6 years ago

BJE 

let
    Source = Table.FromRecords(Json.Document(Binary.Decompress(Binary.FromText("i65WcgtxVbJSMtA1UarVgfEMDQx0DU0sUUR0jVBUmAJVWCKrMDIw0EbmmuqiGABUj6LcVBfIiwUA",BinaryEncoding.Base64),Compression.Deflate))),
    sort = Table.Sort(Source, {each Number.From(Text.SplitAny([FTE],"-+"){0}), Order.Ascending})
in
    sort

If my code solves your problem, mark it as a solution