Forum Discussion
Remove rows based on an arbitrary rule
Because the rule is completely arbitrary, and I know for a fact that the order of the rows, as well as the number of them, won't ever change, I solved this by simply creating an index column and filtering by it, manually removing the indexes I'm not interested in. In the end it was a very easy solution.. Thanks anyway guys!
Hi jonoren,
What is your selection logic to choose BTN vs INR? Can this be formalised to be programmed? If this is based on some "knowledge" you will need a translation table in the fashion that MarCat mentioned.
Otherwise the method quite simple. Instead of choosing Expand when expending column choose Aggergate:
and then select anything (Count would do). Once the step is created change List.Count in the formula to List.Last or some other computation that would produce a single result from a list of options.
If you need more help on this one, share your computation logic over selecting a paarticular currency from multiple options.
Thnaks,
John