Forum Discussion
jimpatel
Post Patron
2 years agorelatedtable
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
- jimpatel
Post Patron
Perfect
Thanks a lot