How to do VLOOKUP functions in Power BI?

---

parry2k wrote:

kwpbi here are the steps;

 

- add table visual

Do you mean create "New Table" on the "Modeling" tab? I'm working with Power BI Desktop, by the way. not sure if that matters but I forgot to mention it.

When I try to create a new table, it wants information in the formula bar. I'm not sure what to put there. If I don't put anything in there, it doesn't make a table. If I make it equal another table, the two become linked and I cannot change the new table without it also changing the original table.

- put work order number from table 1 on values

I don't know what "on values" means. Can you explain what ribbon tab(s) and command(s) I would be using to do that? Or explain in more detail what you mean by putting something "on values"?

- put scrap qty from table 1 on values, and there is arrow key next to scrap qty on values, click that, and choose don't summarize

- put good qty from able 2 on values

 

you will get the result.

 

if it doesn't work then tell step by step what you did and what you are getting

Like I said, I don't even know where to start. All I want to do is create a new table that only contains the work order number column and good qty column from my original table, and then sum up the good qty's for any recurring work order numbers in that table.

Here is what I tried to do:

step 1: Create new table from original table, enter this in formula bar (Table = AX_TRANSACTIONS)

step 2: No matter what I do next, it affects both tables. I need my original table to stay as-is. So I am stuck here. I do not know how I can complete the simple task of making a new table that has only those two columns, with summed up good qty's, without affecting my original table. Frustration station!

---