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,

 

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.

      • mussaenda's avatar
        mussaenda
        Community Champion
        7 years ago

        Hi, Ashish_Mathur,

         

        The value of the week52 of 2018 will still be added to week1 of 2019. If not mistaken, this what we call cumulative? Please enlighten me as I am really new to PBI.

         

        Again, thank you for your help. It is highly appreciated.

         

        Mussaenda