Forum Discussion
Helper IIHow to do VLOOKUP functions in Power BI?
Super UserIf 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.
Helper IIjdbuchanan71 wrote:
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.
I'm sorry but I don't really understand what you are describing, or how to do it. If I had more experience with Power BI it might make more sense but at this point I wouldn't know where to start (how to make that "combined table" for example).
- parry2k
kwpbi here are the steps;
- add table visual
- put work order number from table 1 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
- kwpbi
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!
