I have a table pulled from multiple csv files using Power Query.
There are a few columns that matters: Date, Client ID, Status (Failed/Success)
Basically I can see there how many times they failed to do something.
I have 3 scenarios
1. Failed
2. Failed and succeeded after
3. Succeeded without failing (this is what I don't need ant I want to filter out)
I want to be able to see this by date.
So I need to delete scenario 3 based on Date and CID (because during the month he can try multiple times).
can I do it from power query so my final data table will not need any modifications?
Bookmarks