Use a step as filter for previous step

[Anonymous]

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)?

[lbendlin · Accepted solution]

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.

[Anonymous]

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).

[lbendlin]

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"