Forum Discussion

JustyceW's avatar
JustyceW
Frequent Visitor
9 years ago
Solved

How to reference another table in Query Editor (M)

Hello,   I am attempting to reference a table for a custom column in the Query Editor mode of Power BI desktop.   The formula will be similar to the solution found in the following link.    "= ...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    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".

     

     

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

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".

 

 

JustyceW's avatar
JustyceW
Frequent Visitor
9 years ago

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