Hello I am trying to use Excel Power Query to do the following. I have multiple columns Order / Item / Version / Qty / Price

I have multiple versions of Order Items so want to keep the last version of the record I'm thinking keep order item where version is max.

use arrows atop the new column to expand all the columns [x] except the ones you used in the initial group; here we just need to [x] version column

Add column .. custom column ...

= if [Count]=[#"CHANGE_VERSION_NUMBER"] then "keep" else "remove"

Then use the drop down in that column to unitick and filter out [x] the remove word

Right click and remove any extra columns

file.. close and load .... your data back into excel