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

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Yes.  That is waht cumulative is.  It is not a technical BI term - it is just a simple English word.  What result do you get when you put in data for 2018 as well?

    • mussaenda's avatar
      mussaenda
      Community Champion
      7 years ago

      Alright, it is a simple english word.

       

      From the pbix that you attached, and using YearISO from Date Table as slicer, the data for 2018 is correct.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

        Reivse the two measures and see if the result is now corrrect

         

        Orders received till date = CALCULATE([Orders received],DATESBETWEEN('Date Table'[Date],MINX(all('Date Table'),'Date Table'[Date]),max('Date Table'[Date])))
        Orders shipped till date = CALCULATE([Orders shipped],DATESBETWEEN('Date Table'[Date],MINX(all('Date Table'),'Date Table'[Date]),max('Date Table'[Date])))