Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Lookup Possibility

Given my unfamiliarity with Many to Many relationships, my research on the internet has failed to provide a clear solution to this problem. I have a data model that currently has two lists with a Man...

Anonymous
6 years ago
Nevermind. I found a simple solution through the DAX function of Lookupvalue. If you simply put:

Calculated Column = LOOKUPVALUE( Table 1[Rank], Table 1[Name], Table 2[Name], Table 1[Code], Table 2[Code])

You should get the desired result.