Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Consolidate 2 tables

Hello,

 

I have 2 tables that I would like to consolidate (DOLLAR table and QTY table) so that it will look like this.

 

 

Is there a way to relate these 2 tables below?  I tried to relate them using the Document No but it seems that the resulting numbers are off. 

 

Here is the sample pbix file.

sample.pbix

 

Thanks. 

 

 

 

 

Need Help

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    2 years ago

    Hello Oros ,

     

    you need to understand what every table means with the data inside it and what's the relation between these two tables. it's not about what field goes with the other but it's how the data is structured.

     

    so in order for this to make sense, you need to understand the relation between these two tables then you see how to link them.

    • Oros's avatar
      Oros
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      Hi Idrissshatila,

       

      Thank you for your quick reply.  Here is the sample pbix file. 

      sample.pbix

      I highly appreciate any further guidance.  Thanks.