create new Column

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

IN DAX
https://1drv.ms/u/s!AiUZ0Ws7G26Rixu4oV5LW2VcErUY?e=4oFKH2

Hi shri0025 ,

Please try below steps:

1. add an index column in Power Query pane

2. create a new column with below dax formula

Column =
VAR cur_entry = [Gate entry]
VAR cur_index = [Index]
VAR tmp =
    FILTER ( 'Table', [Gate entry] = cur_entry )
VAR _a =
    MINX ( tmp, [Index] )
RETURN
    IF ( cur_index = _a, [Freight Amount], 0 )

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.