Forum Discussion
Use a step as filter for previous step
Hi. Fairly new to power query.
I want the Filtered Rows deleted in the Changed type.
Also is there a list or website of all the commands in Power Query (ie SelectRows)?
1. Right click on Filtered Rows, then "Move before".
2. Power Query comes with all the documentation baked in. Use #shared for a complete list of every single command and function and artifact. Each artifact comes with documentation too. Type
= Table.SelectColumns
to see the documentation for that function.
3 Replies
1. Right click on Filtered Rows, then "Move before".
2. Power Query comes with all the documentation baked in. Use #shared for a complete list of every single command and function and artifact. Each artifact comes with documentation too. Type
= Table.SelectColumns
to see the documentation for that function.
1 I should been clearer what I'm trying to do. The Filtered Rows is data I want removed from the Changed Type while keeping the rest of the data. If the two steps could be joined (either by joining the data or coding a step to do a join/filter).
(note : I found an alternate solution : use a multi condition filter). I would still like to see if there is a solution using the join)
2 Where do I use the #shared? I've tried the help, the steps, and Google (just in case).
1. Any solution that does not use a join is better than a solution requiring a join. Read about query folding too.
2. create a new blank query, enter "= #shared"