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 Servi...
#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.