return max date

[Anonymous]

Hi Everyone,

 I need help

I want to retrieve  max date for every user from using edited Query "advance editor ", before load data into the data model 

I want to remove duplicate  based on data and remaining just last data

like the scenario below in tables   :


                                    

I want show data jsut inside table after loading  table 

Regards,

[kcantor · Accepted solution]

@Anonymous 

If you want to complete this in the Query Editor, you would simply choose to "Group By" and then Group by ID with the agregation of Max Date.

Group by will be on the Transform Tab. When you select it, put your ID in the Group by selection. Below that, rename your column "Max Date" or what ever you prefer. The operation would be "Max" and the select the final column of Data. This will leave the results you are looking for.