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