Each value=[Table] after merging and expanding 2 tables

[ri2sina]

Hi!
Need a help!

I have 2 tables.
The first one consists the titles of the sites by it's ids.
The second have some values for each site_id.
I need to know the site titles in the second table.
For this I mergedthe first table to the second by the column "site_id".
After that I expanded the column site_title.
And I got "[Table]" instead of each site_title value.

Thanx for any suggestion!

[v-yuezhe-msft]

Hi @ri2sina

Could you please share the sample data in your two tables? And how do you perform the merge process? After you merge the first table to the second table, you would get the result as below in Query Editor.


Then please click the arrow button on the upper right corner as shown in the following screenshot and only select the title field.


This way, check that if you get the expected result as follows.



Thanks,
Lydia Zhang

[ri2sina]

@v-yuezhe-msft

http://prntscr.com/cq1gn4
http://prntscr.com/cq1gck

then after expanding
http://prntscr.com/cq1h0d

[ankitpatira]

@ri2sina Instead of doing that ensure there is active relationship between two table ie from table1 siteid to table2 siteid. Then for table2 create calculated column using below,

table2NewCol = Related(table1[titleColumn])

[ri2sina]

@ankitpatira this funsction doesn't work((
I wrote the same like =Related('table name'[title])

[ri2sina · Accepted solution]

@v-yuezhe-msftThe problem is resolved.
The main problem was that in expanding window the column names were duplicated.
At first there were only column titles, then there were column titles with table prefix.

If I choose the second titles with table prefix, it won't expand, if first - everything is ok.

Thank you for trying to help!