Picking up rows corresponding to tower Model ID with the highest base ITEM Number

[Anonymous]

Hi Guys, 

I have these 2 columns in addition to others and my objective is pick up only those rows as shown below corresponding to the highest base index in the item column. ( Item is text here but I dont want to lose 5.10 as it is becoming 5.1 after changing to decimal numbers)

So I want to finally have the table with the entries corresponding to 5.1, 5.2 , 5.3.......5.13 for tower Model ID for 24422.

How can I achieve this ?

[lbendlin · Accepted solution]

- add a column that interprets the item as an Integer

- group by TowerModelID and add a max aggregation over the new column, and another aggregation with all rows

- expand the grouped rows

- filter the result to only keep rows where the max aggregation equals the newly created column.

[Anonymous]

Thanks a lot @lbendlin !!! A great and an elegant solution in power Query itself !! Thanks again..