De-duplicating A Table - Using Group function

[Anonymous]

Hi

I have a table which I'm trying to deduplicate using the group function, example of the data is below, simplified as there are alot of columns: 

Source ID	AP Number	Date Created
ID_123	AP_987	01/01/2023
ID_123	AP_654	01/02/2023

I've geoupled by the Source ID and used Max for the created date to get the most recent row, however when I expand the columns out again, it's pulling in all the dulicate rows again, rather than just the ones selected using the group function: 

Is there way to only expand the rows which have then been fltered out using the group function as i's causing some issues with the reporting?

[ryan_mayu]

could you pls provide some sample data and expected output?