Forum Discussion
Solved
I'm unable to structure Power Query Table in a way to get my desired result.
I have 3 tables coming from Power Query. 1) Cost of ingredients which change with date 2) Fixed Recipes of product 3) Unit Produced of product date wise I want to make a table of cost of produc...
I'd transform Query2 to
(query Receipts)
Next, "Receipts produced" as
Join first with second ("Produced") to have details
Combine it with query 1 (Ingredient Price) to receive price per day ("Prices")
Join Produced with Prices to have final costs
And be sure you have same names among all source tables, I guess "Almond" and "Almonds" shall mean the same.
First you should change Query2 and Query3 to get an output of Recipe-Ingredient-Units for Query2 and Date-Ingredient-Units for Query3.
- I've added dummy raw data for Query2, in the file I attached.
I can't understand how to structure it. Can you help me with that.
Query3 is data entry of how many units are produces, there isn't a need for ingredients there.I re did the query 2 and 3.
Detlef_Lewin
Is this what you were suggesting? I'm really confused at the moment.
I'm attaching the file with the power query. It would mean a lot if you could have a look.
Also how do we reach the final output from here?
