relatedtable

[jimpatel]

Hi,

Thanks for looking at my post.

Is there any DAX formula to get information from another table but they are not linked to each other please?

I tried to use relatedtable but no luck.

I have 

Table1 = names, Age, Date

Table2 = names

I wanted to transfer last date from table1 to table2 for those respective names please

Any idea please?

Thanks 

[jimpatel]

Perfect

Thanks a lot

[xifeng_L · Accepted solution]

Hi @jimpatel 

You can use the LOOKUPVALUE function, which does not require the relationship. eg:

calculated column = LOOKUPVALUE('Table1'[Date],'Table1'[Names],'Table2'[Names])

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~