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

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