Forum Discussion

kwpbi's avatar
kwpbi
Icon for Helper II rankHelper II
7 years ago

How to do VLOOKUP functions in Power BI?

I am reposting this question in a more clear and concise manner with the hope that someone can/will help.   I have two tables. Table 1 has work order # and "scrap qty". Table 2 has work order # and...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

kwpbi you need to set many to many relationship between table 1 and table 2 on Work order. As far as you don't care about work order which doesn't exists in table 1 but table 2 (for example 5550),  solution will work.

kwpbi's avatar
kwpbi
Icon for Helper II rankHelper II
7 years ago
parry2k wrote:

kwpbiyou need to set many to many relationship (for example 5550),  solution will work.

It already is a many-to-many relationship (can't be anything else).

I'm not sure where to start in Power BI to accomplish this task. The logical first step, as I have mentioned, is to create a new table that totals up all duplicate work order rows in my "good qty" table. Then I believe I should be able to create a one-to-many relationship between that new table (with the duplicates combined) and my "scrap qty" table to get the new column I am after. Does that sound right?

If so, then maybe all I need help with is how to create that new table where the duplicate work orders have been combined?

thanks.