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 !
Hi,
can you post some fake data (not images) and the result you want to obtain
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 !