jlhoover3
Board Regular
- Joined
- Nov 9, 2015
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
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!
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!
Power Query:
= Table.SelectRows(#"Removed Other Columns", each ([position] <> "Hold"))