Get and Transform (Power Query) - Grouping numbers into bands/buckets

Hi

Wonder if anyone can advise on this challenge I am facing please?

In excel I would just use a lookup without True/False (1/0) to determine where a number "fits" in a list of bands but lost on it in G&T. I am looking at the number of staff managers have, I would essentially have a list of managers names in the first column and their staff headcount in the second column, in the third column I want to assign a band to the headcount so, for example:

1-5 Staff
6-10 Staff
11-15 Staff
More than 15 Staff

The list is vast and I am performing a number of manipulations on the data in Get and Transform, so ideally I would like to add this step to my Get and Transform rather than doing it in excel. I am 100% sure that it can be done but my searches have proved fruitless (I am sure I am just using the "wrong" search term when I say band or group).

Thanks

TNU

I don't know much about PQ etc but have you tried adding a conditional column?

Please Login or Register  to view this content.

the Group element on the G&T is really about thinning the dataset relative to existing values.