Grouping Similar Data Entries but Using Latest Record Only

[markefrody]

Hi everyone,

I have this data table containg different dates and values. If you can notice there are dates that have similar values:

What I want is to make only 1 record for those similar values and then capture the latest date which those similar values are sharing:

The final ouput will look like this:

Is there a way to create this in Power BI? Appreciate your kind assistance.

Best regards,
Mark V.

[AllisonKennedy · Accepted solution]

@markefrody 

You can use Power Query:

Group By the columns with the similar values in your example Select columns for Value A, B and C then in the Transform tab > Group By. Then in the section below to add more columns, select Max, then choose the Date column. 

Alternatively you could use 'remove duplicates' after doing a sort and table buffer, but I think Group by is more performant (not sure though).

[markefrody]

Thanks @AllisonKennedy. Works perfectly!