Forum Discussion

alk's avatar
alk
Frequent Visitor
8 years ago

Line Chart Cumulative sum

Hello all,   I am currently working with data that looks at the creation of new product records over time and wanted to make a line chart that shows running total over months. So I tried looking at...
Need Help
alk's avatar
alk
Frequent Visitor
8 years ago

Hello v-yulgu-msft ,

 

Sorry for clarity purposes the [Status Over Time] field is an updating list of dates based on the date the product status was changed. Therefore, the date the record for the product was created there would be no value(as record creation date is not recorded from the data we pull), the date the product is in production the date will change to that date and if the product is shipped, the [Status over Time] will be changed to the date it was shipped. The created count changes to 1 if the product is in production and 0 if the product is not. If a product has been shipped, it was in production at some point and should be included in the running total

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi alk,

 

Running Total SUM = CALCULATE (SUM(' Report'[Created Count]), FILTER( ALLSELECTED(' Report'), ‘Report’[date_added] <= MAX ( [Status Over Time]) && MIN([Status Over Time]) <= TODAY()))

 

I still have some concern:

  1. There is no [date-added] column in sample table. 
  2. What does the highlighted part mean? 
  3. Should we consider the "Product status", whether it is "In production" or "shipped" when calculating running total?
  4. Please use a column list to show us your desired result (the correct running total value) based on above sample.

 

Regards,

Yuliana Gu