Forum Discussion
Powerquery devide a columns into three equal sized groups/bins
Hi, I have have a column with countries and next to them a RANK (whole number 1-65, depends on the dataset) - I would like a measure which places each country into a group or a tier. For instanc...
Thanks - but it wont work if my next dataset will have 40 countries... thus I need the calculation to look at the entire grou, like an ARRAY in excel
KristofferAJ , it won't happen dynamically, you will always would adjust it as per your dataset.