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})

iWonder's avatar
iWonder
Helper I
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

iWonder's avatar
iWonder
Helper I
5 years ago

Hi wdx223_Daniel 

 

After some more thinking, I've selected my FlockSummary query and clicked the fx button. When I do that I get

 

= #"some big long guid"

 

I replaced that with your formula.

 

Then I get "Expression.Error: A cyclic reference was encountered during evaluation."

 

I must be doing something wrong

  • iWonder's avatar
    iWonder
    Helper I
    5 years ago

    Hi wdx223_Daniel 

     

    I'm continuing to play around with this and I sorted a column to see the code generated.

     

    = Table.SelectRows(#"BIG LONG GUID", each ([Title] = "users email address here...") and ([CustomerAccess] = "ALL"))

     I filtered the Users query by Title (which is email address [took it out for privacy]) and the CustomerAccess column.

     

    The spot where the table name goes is a BIG LONG GUID. If I change that to Users and click the check mark, I get an error:

    "Expression.Error: A cyclic reference was encountered during evaluation"

     

    Do I need to do a rename somewhere?

     

    Thanks

    • iWonder's avatar
      iWonder
      Helper I
      5 years ago

      OK I got it!

       

      I did a Merge Queries as New from the Home tab. It generated the code. I then replaced the generated code with the formula you sent and I'm in business!

       

      Thanks