Forum Discussion

mussaenda's avatar
mussaenda
Community Champion
7 years ago

Outstanding Qty by Week

Good day,   I am rephrasing my question form my previous post. I have three tables, Sales Table, Shipment Table, and Date Table.   What I needed to achieve is the outstanding qty by week.     ...
Need Help
Show and Tell
Tutorial Requests
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Share the Date Table.  Ensure that there is a week column in the Date Table.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

    • mussaenda's avatar
      mussaenda
      Community Champion
      7 years ago

      Hi Ashish_Mathur 

       

       

      Thank you so much for your answer. This is really what I need but for the first weeks of 2019, it cannot be negative because at the end of 2018, we still have the outstanding. Sorry it is my fault because I did not state things clearly. The outstanding qty must be continuous as we are tracking the flow of it.

       

      Thank you so much. You are really a great help to the PBI community.

       

      Regards,

      Mussaenda

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        You are welcome.  So what exact answer are you expecting.  Share that som that i can revised my measure to arrive at your expected result.