Forum Discussion
Solved
PowerQuery Remove Rows dependent on value in column.
Labelling software generates a transaction report that represents each label generated, I pull data from this report using PowerQuery. Each row is an individual label or transaction. When an erro...
Alternative:
- Group by [Serial Number]: Count Rows + (keep) All Rows
- Filter out [Count] > 1
- Combine tables (with Advanced Editor)
- Thank you! with your suggestion, I was able to find a solution.
I ended up creating a helper merged column with PPN-DATE-SERIAL, then grouped by this column and filtered out any rows >1. Then I just expanded the All-rows column and removed the helper column. Thank you!
