Forum Discussion

jimpatel's avatar
jimpatel
Icon for Post Patron rankPost 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.  ...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    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~

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

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~