Forum Discussion

sslavin's avatar
sslavin
New Member
8 years ago
Solved

How to conditionally filter a column in Power Query

I have a table in Excel I am extracting rows from user Power Query. I also have an input cell on the output worksheet where a user can enter a value to filter the results.  I have successfully set th...
  • ImkeF's avatar
    ImkeF
    8 years ago

    You can add a step with a condition like this:

     

    if MyParameter <> null then PreviousFilteredStep else PrePreviousUnfilteredStep

     

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
8 years ago

You can add a step with a condition like this:

 

if MyParameter <> null then PreviousFilteredStep else PrePreviousUnfilteredStep