Forum Discussion
KristofferAJ
Helper III
Helper IIIPowerquery 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...
KristofferAJHelper III
Helper IIIThanks - 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
Idrissshatila
Super User
Super UserKristofferAJ , it won't happen dynamically, you will always would adjust it as per your dataset.