Forum Discussion
Relationship between multiple columns in one table and one column in a lookup table
Hi, I'm very new to PowerBI so this question may be too easy, but I hope someone can help me with it anyway: I have one table with 3 columns: CaseNumber, OwnerID and CreatedByID. I also have ...
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.
az38
Community Champion
Community Championhi 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