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
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

If you pull in the work order # from the combined table and the scrap # from the scrap column of the scrap table and set that field to 'do not summarze' and the [Good Amount] measure you should get what you are looking for.  It will repeate the full good amount on each work order line but the srap amount will be ech entry from the scrap table.

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.