cancel
Showing results for
Did you mean:
Regular Visitor

## Dax or Power Query (M) Formula for duplicate values in the same column

If anyone could help me write a dax or power query formula for the two steps below I would greatly appreciate your knowledge.

1. If Column A has a duplicate value, and the value in Column B is the same, then return the record with the most recent date.

2. If Column A has a duplicate value, and the value in Column B is NOT the same, then keep both records.

I'm trying to achieve one formula that can account for both requirements. I've attached images of sample data to better explain.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Dax or Power Query (M) Formula for duplicate values in the same column

Could you please explain that why you have duplicate values for first row? I make a test using the following sample table instead, and create a measure in the table.

`maxdate = MAX(Table[Date])`

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Moderator

## Re: Dax or Power Query (M) Formula for duplicate values in the same column

Could you please explain that why you have duplicate values for first row? I make a test using the following sample table instead, and create a measure in the table.

`maxdate = MAX(Table[Date])`

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Dax or Power Query (M) Formula for duplicate values in the same column

There are duplicates because an entry can be made on the spreadsheet on different days. I am needing to select the most recent date if Column B is the same. If Column B is different then I need to keep both rows.

After creating the measure I am still seeing duplicates.

Regular Visitor

## Re: Dax or Power Query (M) Formula for duplicate values in the same column

@v-yuezhe-msft

I figured out the error. I was adding the table date column instead of maxdate. Your answer worked perfectly, thank you!