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
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])))