cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lbrown Regular Visitor
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. sample 2.PNGsample.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

@lbrown,

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])

1.PNG2.PNG


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 v-yuezhe-msft
Moderator

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

@lbrown,

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])

1.PNG2.PNG


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.
lbrown Regular Visitor
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.
 
maxdate.PNG
lbrown Regular Visitor
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!