Most efficient way to load a table of constants

[Anonymous]

Hi everyone,

I have a table of items with prices in one query, and need access to add them in different combinations within a second query.

In Excel, I'd use some kind of VLOOKUP. I know one way to do this in Power Query would be to merge the queries, which would make all the prices appear in every row of the second query. This would enable my calculations, but seems very untidy and probably inefficient.

Is there a better way look up prices in another query?

[ray_aramburo · Accepted solution]

Merging queries is the right thing to do as long as you don't have a many to many situation, then merging queries would require for you to have or create a combined key. 

[Anonymous]

Thank you! It means having a load of values exactly the same on every row. But if that's what it takes, I'll do it!