Forum Discussion

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

One Order Date with Multiple Shipment Dates

I am a newbie in power bi and I am dealing with some problems.   I have 3 tables: Sales Table, Shipment Table, and Date Table. In Sales Table, I have the the Order Date, Job Number, the Qty of the...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi mussaenda ,


You can add another 'qty base' to value fields, rename these fields based their table name.(sale qty, shipment qty)

After these steps, you can add a measure to get diff from two qty and group by current category.

 

It will display remain qty which you wanted.

 

Regards,

Xiaoxin Sheng

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous,

 

Thank you for suggesting. I tried to add the order qty in the matrix but it is duplicating base on the rows of date. If you will enlighten me on grouping by current category, it will be a big help since I am a newbie. Bear with me.

 

See photo below, Thank you!

 

 

 

Warm Regards,

Mussaenda

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi mussaenda,

     

    You can drag this column row fields after order date, then it will display as total amount of shipment qty.(I rename two fields as sole qty and shipment qty)

     

    Regards,

    Xiaoxin Sheng

    • mussaenda's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Hi Anonymous,

       

      Maybe my questions were not clear. Sorry for that. I will post a clearer question. Thank you for answering my question here, you are brilliant.

       

       

      Mussaenda