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

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.

JustyceW's avatar
JustyceW
Frequent Visitor
9 years ago

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

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    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.