Forum Discussion
Solved
Delete rows based on condition in M PoweQuery
Hi, How can I delete the rows that do not contain highlighted cells? The highlighted cells contain the most recent order date for a particular customer id. I want to keep only the rows where the ...
Hi,
In the Query Editor, right click on the first column and go to Group. Select Max in the function there.
Hope this helps.
Thanks a lot, Ashish!
You are welcome.