Power Query - Filter table column based on cell value

[jlhoover3]

Hello all,

I'm digging into Excel a little deeper and introducing myself more to Power Query. What I am creating now is keyword search database for our custom CRM. Currently I pull our CRM data from a web query into an Excel Table. I have all that functioning correctly. What I want to do is if a certain cell (cell F4 or named "HOLD_STATUS") is equal to "No", then I want to filter out any position that's currently in "Hold". I'm able to do that statically (see code below), but I want to make that dynamic to the cell's value. I'm horrible at describing exactly what I'm looking for, so if there's any questions then feel free to ask. I appreciate your help!

= Table.SelectRows(#"Removed Other Columns", each ([position] <> "Hold"))

 

[alansidman]

What you are describing is a Parameter Query. MrE has a very good tutorial that will show you how this works. Click on the link below to watch.

 

[jlhoover3]

My man... thanks so much for the tutorial link. Worked like a charm and my query is working properly!

 

[alansidman]

Thanks for the feedback. Happy to have helped/