Calculated column from another table column in the same data model

[stribor45]

How would I add a column from another table into my table using "Custom Column"? When I try to populate a custom formula and enter #"My Other Table" how do I reference that column now? The only available columns are the ones from the table where I want to bring that column over. This tutorial doesn't show examples when you want to copy from another table Custom Column 

[v-jianboli-msft]

Hi @stribor45 ,

First select the eligible rows to produce a Table by using Table.SelectRows():

Table.SelectRows(DETAILSTABLE,((x)=>x[Key]=[Key]))

Then select the columns you want to generate the list:

Table.SelectRows(DETAILSTABLE,((x)=>x[Key]=[Key]))[Answer]

Get the value from the list by index position:

Table.SelectRows(DETAILSTABLE,((x)=>x[Key]=[Key]))[Answer]{0}

Final output:

Best Regards,

Jianbo Li

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

[stribor45]

Would you be able to explain this function/condition below? In the "Custom1" column you copied the table with one column but I am confused about how are you accessing values in that column. Nowhere in your formula, you are referring to that "Custom1" column

(x)=>x[Key]=[Key]{Answer}{0}

[v-jianboli-msft · Accepted solution]

Hi @stribor45 ,

Based on your description, I have creaeted a simple sample:

If you need to add the column Answer in SUMMARIZE TABLE:

Best Regards,

Jianbo Li

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