Forum Discussion

GrahamR99's avatar
GrahamR99
Icon for Resolver I rankResolver I
8 years ago
Solved

Sales 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...
Need Help
  • Abduvali's avatar
    Abduvali
    8 years ago

    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

     

     

GrahamR99's avatar
GrahamR99
Icon for Resolver I rankResolver I
8 years ago

Hi Abduvali

That is almost it, I can't get Region and Area to display on one pivot.

 

This is what I have;

How do I get it like your last image?

 

Regards

 

GrahamR99

Abduvali's avatar
Abduvali
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

Use Matrix table and expand:

  • GrahamR99's avatar
    GrahamR99
    Icon for Resolver I rankResolver I
    8 years ago

    Hi 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's avatar
      Abduvali
      Icon for Skilled Sharer rankSkilled Sharer
      8 years ago

      Are you talking about sales quantity???

      • if so drag and drop your quantity into Values field and select SUM