Relationship between multiple columns in one table and one column in a lookup table

hi Anonymous 

for example, you can create a calculated column in your 'Table1':

Column = 
LOOKUPVALUE('Table2'[FullName];'Table2'[UserId];'Table1'[CreatedByID])

do not hesitate to give a kudo to useful posts and mark solutions as solution

Hi Anonymous ,

use LOOKUPVALUE.

https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

For more information look at this.

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.