Forum Discussion
Solved
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...
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')
I would recommend using the query editor to merge the queries.
https://www.lynda.com/Power-BI-tutorials/Merging-data/445425/477071-4.html
