Forum Discussion
Solved
How can I group like rows ?
I have a table with the following: NAME KEY Added DATA-123 Removed DATA-123 Committed DATA-456 Added DATA-789 What I need is to know if the KEY has a Removed, to filter t...
I decided on making a clone of the table and just having "removed" in there and merge it back and filter out those records with Key as null, it appears to work and needed to have this due to time sensitivity, but thanks all for your assitance and ideas.
I have this, but it seems to take quite awhile to refresh:
= Table.SelectRows(Custom1, (r)=>
let
allKeys = Table.SelectRows(Custom1, each [KEY] = r[KEY])
in
not List.Contains(allKeys[NAME],"Removed",Comparer.OrdinalIgnoreCase))
That seems almost identical to what you wrote previously. I had given you a list of possibilities for slowness. I am afraid that without access to a data set example that can reproduce the problem, I don't know what to add about the slowness.