Forum Discussion
Use a step as filter for previous step
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. 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"