cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mohammed Member
Member

return max date

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   :


er100.JPG                                    er101.JPG

 

I want show data jsut inside table after loading  table 

Regards,

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: return max date

@mohammed 

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.

1 REPLY 1
Highlighted
Super User
Super User

Re: return max date

@mohammed 

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.