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 

 

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