1:1 Relationship

[Anonymous]

Hello, 

Say I have a table as follows:

Index No      Cost

1                    10

2                    20

3                    30

4                    40

I have another table as follows:

Index No      Remarks

1                      AA

2                      BB

I have created a 1:1 relationship via the index no column. I now want to merge the tables so that there's a remarks column for each index number. If the index number has a remark then the remark shows otherwise the row is left empty. 

[Anonymous]

Hello, 

Say I have a table as follows:

Index No

[VahidDM]

I think you posted this by mistake. I answered your previous post, please have look and remove this post.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[VahidDM · Accepted solution]

Hi @Anonymous 

Add a new column and use the below formula:

Remark Column = RELATED('Table 2'[Remarks])

Output:

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube