Forum Discussion
How to reference another table in Query Editor (M)
Just the name of the table, which is equal to the name of the query from which the table is the result.
If the name of the query (table) contains spaces or other special characters, the name must be included in #"....",
e.g. #"Table name".
Hello,
It looks like that works!
The problem now is I am getting an error:
"Expression.Error: A cyclic reference was encountered during evaluation"
Here is my formula: = List.Count(List.FindText([Initiative],Table.Column(#"Master - Milestones",[IdeaID])))
For context, I am trying to count the number of milestones for each initiative. The initiative is the key for my current table and the foriegn key in the "Master - Milestones" table.
I would be grateful if you could help me resolve this error and achieve my desired output.
Best,
Justyce
It's hard to say. Referencing a column in another table is not a problem as such.
The issue must be related to your entire query structure, e.g. 2 tables referencing each other.
Thank you for your replies:
Based on your experience, do you think this error is caused by a join between the Initiative and Milestone tables or because they are linked like a database?
Best,
Justyce
You're welcome.
I have no answer to your last question: I've studied Power Query Formula Language quite thoroughly, but my experience with Power Query and databases is close to zero.