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