Link to another table in the column of a table

[Syndicate_Admin]

Is there a way of having a column in a table link to another table and can it be done on the tables screen?

Would that column be usable as a source for a gallery?

[v-stephen-msft]

Hi @SendHelp1,

In DAX, you can use the RELATED() function if the current two tables have already a relationship.

Or, you can use the DAX LOOKUPVALUE() function if you can’t create a relationship between the two tables.

However, if your requirements need to use Custom Column in Power Query Editor, so you can reference a column from another table in a Custom Column using the below formula:

TableName[Field Name]{Row Index}

Also, you could try to use merge or append in the Power Query Editor.

Merge queries (Power Query)

Append queries (Power Query)

Reference: How to add a column from another table in Power Query? - deBUG.to

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.