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 there,
i have a data table with columns ServiceDirectionCode and DateTo
I would like this data table to give me all the different ServiceDirectionCodes, and for the duplicate codes, I only want to keep the row with the latest DateTo.
Is this possible to do in the Query Editor?
Thanks,
Wes
Solved! Go to Solution.
Hi,
You may use the Group By feature and take the maximum of the DateTo column.
As @Ashish_Mathur suggsted, just have your records group on Code level with max aggregation on Date column.
Regards,
As @Ashish_Mathur suggsted, just have your records group on Code level with max aggregation on Date column.
Regards,
Hi,
You may use the Group By feature and take the maximum of the DateTo column.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |