Forum Discussion
Using LOOKUPVALUE with the same columns more than once
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')
Thank you for your response!
One of the tables is a reference table with SKU information, the other is data is order data pulled from a system. The pulled data would be a list of orders that would have a SKU column that looks like this:
SKU 1
SKU 1
SKU 1
SKU 3
SKU 2
SKU 3
SKU 1
I want to be able to look for each SKU in the reference table and pull information to the pulled data like description, etc... I am not sure merging the queries would work in that case. Then again, I am a PBI / DAX n00b.
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')
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?
