Forum Discussion
Filter and remove data in Power Query
Hi,
You can try this way:
- add a custom column
- group by
- choose columns
- expand
- and finally filter rows (and delete unnecessary column)
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Rec # original qty traveler counter
| 226171 | 1 | 1 | ||
| 226331 | 1 | 1 | ||
| 226243 | 1 | 1 | ||
| 226246 | 1 | 1 | ||
| 226196 | 1 | 1 | ||
| 226316 | 2 | 1 | ||
| 226305 | 1 | 1 | ||
| 226296 | 1 | 1 | ||
| 226287 | 1 | 1 | ||
| 226221 | 1- | 1 | ||
| 226221 | 1 | 1 | ||
| 226314 | 1 | 1 | ||
| 226230 | 1 | 1 | ||
| 226251 | 1 | 1 | ||
| 226259 | 1 | 1 | ||
| 226308 | 1 | 1 | ||
| 226286 | 1 | 1 | ||
| 226370 | 1 | 1 | ||
| 226307 | 2 | 1 | ||
| 226137 | 1 | 1 | ||
| 226273 | 2 | 1 | ||
| 226328 | 1 | 1 | ||
| 226217 | 1 | 1 | ||
| 226146 | 1 | 1 | ||
| 226265 | 1 | 1 | ||
| 226358 | 1 | 1 | ||
| 226190 | 2 | 1 | ||
| 226279 | 1 | 1 | ||
| 226148 | 1 | 1 | ||
| 226323 | 1 | 1 | ||
| 226317 | 1 | 1 | ||
| 226367 | 1 | 1 | ||
| 226166 | 1 | 1 | ||
| 226453 | 1 | 1 | ||
| 226165 | 1- | 1 | ||
| 226165 | 2 | 1 |
current counter: 36
After filtering column 2 for negative values, gathering the corresponding receiver #s, refiltering column 1 for those values, and deleting all resulting rows, the counter should be 32
Hi,
You can try this way:
- add a custom column
- group by
- choose columns
- expand
- and finally filter rows (and delete unnecessary column)
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !