Forum Discussion
Remove duplicate entry based on calculation between matching rows (datetime difference)
Hey Team! I have very complex problem I'm struggling to resolve. I assume there is several ways to do it. I'm looking for performance wise aproach that can handle milions of rows. Goal: summariz...
Hi MatusiSK ,
The M code you provided is not complete, so I may not know whether there is room for improvement. However, for Power Query to optimize query performance, the most effective method may still be to use Group by Function.
Table.Group - PowerQuery M | Microsoft Learn
Please check whether your data can be grouped first and then perform other data transformation operations.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.