Forum Discussion
How to use if else condition on different queries while creating custom column in Power Query
#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/