Group By Query

Hi Apollo71 ,

ryan_mayu Good answer!
And if you must want to use Group by, you can try this way:
First, Duplicate the Table:

In the new table Table(2), use Group by:

Then in the Table(2), click Merge Queries as New:

Configure as shown in the following figure:

Match the Serial number column of the two tables, and have the Max and Service Date columns match.
The output is as below:

Click here to expand the Table column:

And the final output is as below:

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

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Serial number", Int64.Type}, {"Service Date", type date}, {"Service Engineer", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Serial number"}, {{"Count", each Table.Max(_,"Service Date")}}),
    #"Expanded Count" = Table.ExpandRecordColumn(#"Grouped Rows", "Count", {"Service Date", "Service Engineer"}, {"Service Date", "Service Engineer"})
in
    #"Expanded Count"

What is your data source?  Is it all coming from a single place or no?

If it is coming from multiple places then you may have to look at the connections between your data tables.

Can you upload a sample .pbix file with some bogus data (if the data is confidential) that simulates the problem? 

It's working fine for me, assuming all of the data is coming from a single document:

https://files.catbox.moe/m03b75.pbix

//Mediocre Power BI Advice,  but it's free//