Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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.
Proud to be a Super User!
@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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |