Forum Discussion

saturation's avatar
saturation
Frequent Visitor
6 years ago
Solved

Pull values from 2 tables into a 3rd table

I'm new to Power BI. I'm trying to create a 3rd table that takes columns from the first 2 tables so I can add some additional calculations on those "joined" values. Maybe there's a better way....But ...
Need Help
  • saturation's avatar
    saturation
    6 years ago

    Hi Nathan,

     

    I was actually able to accomplish this using the "Merge Queries" - now I have a table that contains values from both tables. Thank you for your help!

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi saturation ,

 

You should be able to use LOOKUPVALUE()

LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…[, <alternateResult>])


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

saturation's avatar
saturation
Frequent Visitor
6 years ago

Hi Nathaniel,

 

I'm not familiar with the LOOKUPVALUE function. Are you able to help me apply it directly in this example? Just not sure which values go into which parameters...