Hi all
I have below table. Now I wanna create a "Max rate" columns with below logic:
Fill up the Max rate of max distance for 1 shipment in column" Max rate"
Ex: Shipment B have 2 rates with max distance ( 12) : 1719 and 1741 => fill up 1741 into " Max rate" column
So, is there any way to do it with POWER QUERY?
Thanks in advance for your support!

