Data from table using relationship are not populated

[nayanpatel]

Hi Friends,

I have 3 tables related as Table1-->Table2-->Table3. Now, I need column from Table1 into Table3 (No Joins or merging). I need in front end. I Tried with Related and lookupvalue, but its not working. Please help to know the best possible way.

Thankd you

Regards,

Nayan

[Anonymous]

Hi @nayanpatel ,

You can try formula like below to create calculated column:

NewColumn = RELATED(Table1[Name])

NewColumn_ = LOOKUPVALUE(Table1[Name], Table1[ID], Table3[Table2_ID])

Best Regards,
Adamk Kong

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

[nayanpatel]

HI, Thank you for the response !

What if there is no relationship between table and we need to bring value from Table1 to table2 based on Matching Key.

[rohit1991]

hi @nayanpatel ,
If RELATED or LOOKUPVALUE isn’t working due to indirect relationships, use TREATAS in a measure:
ColumnFromTable1InTable3 =
CALCULATE(
MAX(Table1[YourColumn]),
TREATAS(Table3[LinkingColumn], Table2[LinkingColumn]),
TREATAS(Table2[LinkingColumn], Table1[LinkingColumn])
)

Ensures data flows across Table1 → Table2 → Table3 without merging.Also, use in visuals instead of a calculated column.