Forum Discussion
PBIn00b
10 years agoAdvocate II
Using LOOKUPVALUE with the same columns more than once
I am attempting to use LOOKUPVALUE to pull multiple columns of data from one table to another. I am very familiar with using Excel VLOOKUP and INDEX MATCH, but I am new to using DAX. I can get o...
- 10 years ago
I reached out to Power BI support and they recommended I use the RELATED function.
It looks like it worked!
Create a relationship between the two tables, MANY to ONE
Then Column = RELATED('Column from Related Table')
PBIn00b
10 years agoAdvocate II
I reached out to Power BI support and they recommended I use the RELATED function.
It looks like it worked!
Create a relationship between the two tables, MANY to ONE
Then Column = RELATED('Column from Related Table')
Joao_Gabler
2 years agoRegular Visitor
Hi, it seems I have the same problem as you but I'm also new do DAX. Could you please provide furthuer details on how to use the RELATED formula with the LOOKUPVALUE formula?