Removing duplicates from the data

Hi AbbasG 

You can try this method.

First , sort Particular , then sort price by ascending. This is make sure the min price to be the first under the same Particular

And then use the remove duplicate row to remove. Because this remove duplicates rows will all ways keep the first one.

Or you can try dax to reach that. Try column like the following :

Column =
VAR _MIN =
    MINX(
        FILTER( 'Table', [Particular] = EARLIER( Table_DAX[Particular] ) ),
        [Price]
    )
RETURN
    IF( _MIN = [Price], 1, BLANK() )

And select the 1

I put the pbix file in the end you can reference.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.