question

@GonzalezJrCruzAContractor-3237

Within Power BI, Edit the query > Advanced Editor. Now, assuming the query STEP that corresponds to the picture you uploaded is the #"Changed Type" step (otherwise adapt), below that step replace everything with:

     GroupedSerialN = Table.Group(#"Changed Type", {"Serial Number"},
         {"SN_Table", each
             Table.FirstN(
                 Table.Sort(_, {<!-- -->{"Last Sync",Order.Descending}}),
                 1
             ),
             type table
         }
     ),
     CombinedTables = Table.Combine(GroupedSerialN[SN_Table])
 in
     CombinedTables

NB (EDITED) I assumed [Last Sync] isn't ordered/sorted by [Serial Number]. If it is let me know as the above Table.Sort would not be required and Table.FirstN would be replaced with Table.LastN

If you're not familiar with Power Query and struggle implementing this post your complete query code

@GonzalezJrCruzAContractor-3237

If your table is quite large (# records) prefer the following option:

     TableWithLastSync = Table.Group(
         Table.SelectColumns(#"Changed Type", {"Serial Number","Last Sync"}),
         {"Serial Number"}, {
                 {"LastSync", each List.Max([Last Sync]), type nullable datetime}}
     ),
     MergedTables = Table.NestedJoin(
         #"Changed Type", {"Serial Number","Last Sync"},
         TableWithLastSync, {"Serial Number","LastSync"},
         "TableLastSynch", JoinKind.Inner
     ),
     RemovedColumn = Table.RemoveColumns(MergedTables,{"TableLastSynch"})
 in
     RemovedColumn

@GonzalezJrCruzAContractor-3237 Thanks for posting in our Q&A.

For this issue, it is more related to Power BI. It is suggested to try to aggregate the records according to the latest sync time in Visualization. We can refer to the following article:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates#types-of-data

To get more effective help, please post in the Power BI community forum:
https://community.powerbi.com/

Thanks for understanding and have a nice day.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.