Forum Discussion

iWonder's avatar
iWonder
Helper I
5 years ago
Solved

Merge Queries with an IF

Thank you for taking the time to read my question.   I am brand new to Power Query... let's start there...   I have Merged 2 queries in Power Query and have added a Parameter.   One query is a ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    Table.SelectRows(FlockSummary,each if Users[CustomerAccess]{0}="ALL" then true else [Title]= Users[CustomerAccess]{0})

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
5 years ago

Table.SelectRows(FlockSummary,each if Users[CustomerAccess]{0}="ALL" then true else [Title]= Users[CustomerAccess]{0})

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Hi @wdx223_Daniel 

 

Thank you so much for your reply and for the formula.

 

I'm not sure where to put that... do I put it in place of the merged query initial step? Do I add it as a new step to my FlockSummary query (if so, how do you add a new step?)?

 

Thanks again for your help