Forum Discussion

jimpatel's avatar
jimpatel
Post Patron
2 years ago
Solved

relatedtable

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 

  • 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~

2 Replies

  • 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~