topic relatedtable in DAX Commands and Tips

relatedtable

jimpatel — Wed, 05 Jun 2024 14:33:40 GMT

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

xifeng_L — Wed, 05 Jun 2024 14:49:33 GMT

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~

jimpatel — Wed, 05 Jun 2024 14:53:48 GMT

Perfect

Thanks a lot