Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
#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/
#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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.