Adding a new column to a table created with a formula

[Mrafih]

Hi there, Ive created the following table named 'Diff Table' in power BI using dax and want to add a 7th column called 'General name' to the table. The column I want to add exists exactly how I want to copy it over in another table i made called General name and is under a column called name. Ive included a picture of what I want it to look like.

(Diff table)

(General names)

This is a picture of what I want it to look like

I know I didnt explain it very well but any help is appreciated, thanks!

[v-stephen-msft · Accepted solution]

Hi @Mrafih ,

Calculated columns can only reference columns in their own tables. Below is the example.

But you can use the MAX, MIN, SELECTED functions to refer to other tables, but it will return values according to the definition of the function. Depending on your desired outcome, the value of your seventh column is matched against the Name column of the primary table.

The workaround is that your General names table can be created as follows. One column is the Name column of the unique primary table, and one column is the name column you want to match.

Then you can create a calculated column as follows.

Column = RELATED('General names'[name])

In summary, if you don't have a relationship to match rows, it's difficult.

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.