Forum Discussion
GrahamR99
Resolver I
Resolver ISales Data with Stock Booked in Data
Hello I have a Power BI Project, with Query1 Sales Data this has; Product_Name,Region,Area,Product_Range,Year,Week,Sale_QTY,Sale_Value I have a Query2 Stock Booked in Data this has; Product_Na...
Hi GrahamR99,
Try function called Append Queries in Edit Mode:
Table 1Table 2Go to any Table and click Append Queries, you can select Three or more and then manually bring missing TableTables JoinedMerge 2 Region columns by selecting both, right click and select Merge columns and hit OKFinal result, now just drag and drop into your table matrix to complete
Hope this helps.
Regards
Abduvali
Abduvali
Skilled Sharer
Skilled SharerUse Matrix table and expand:
GrahamR99Resolver I
Resolver IHi Abduvali
How do I do a Calulated Field so I need to book_qty - SQTY?
I guess I can not do it on the Append Table as they will have different lines.
Regards
GrahamR99
- Abduvali
Are you talking about sales quantity???
- if so drag and drop your quantity into Values field and select SUM