Forum Discussion
How to use if else condition on different queries while creating custom column in Power Query
I have one query named Location with LocationId(unique), Location_desc
Another query Service Equipment with EquipmentID and locationID(multiple values).
I want to create a custom column in Service Equipment using the following condition
If #Service Equipment"[locationID]= #"Location"[LocationID] then"Location"[Location_desc] else "Null"
Afther that I have appended multiple queries (euipment, Repar) with same column names and data types to get a single query.Which is why I have to create this column in the power query.
I am getting the following error Expression.Error: A cyclic reference was encountered during evaluation.
#Service Equipment" is the name of the query, so you're referencing the end result of the query from within the custom column, which is circular.
Forget the custom column and do a merge with Location and expand [Location_desc].
More resources on merging:
https://www.excelcampus.com/powerquery/power-query-merge-vlookup/https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://blog.enterprisedna.co/how-to-merge-queries-in-power-bi/
2 Replies
#Service Equipment" is the name of the query, so you're referencing the end result of the query from within the custom column, which is circular.
Forget the custom column and do a merge with Location and expand [Location_desc].
More resources on merging:
https://www.excelcampus.com/powerquery/power-query-merge-vlookup/https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://blog.enterprisedna.co/how-to-merge-queries-in-power-bi/
Thanks AlexisOlson , It worked.