Sum based on accumulated values

[Andregewehr]

Hi people!

I have the following table with id_product, date, sells and available_minutes. Every day the database is updated, to check how many sells the product was for sale. The available_minutes is to check if the product has stock above zero.  As I want the average sales (sales/week), if I make a calculation divided by 1 week, I will be considering when there is zero stock. So I want to consider the period of 1 week that the stock is available.

So I created a measure of cumulative sum of minutes:

_accumulate_minutes = CALCULATE(sum('Table'[available_minutes]),FILTER(ALL('Table'[date]),[date]<=MAX('Table'[date])))

So I have this table

As you can see, the total sum for the measure is wrong. I think I should try summarize or addcollumns, but I already tried and did not get the result. But what I really want is to sum the sells for 1 period and 2 periods for each id_product. Each period has 10.080 minutes, so 1 period is 10080 and 2 periods 20160. 

Hope someone can help me 🙂

Thanks!

André Gewehr

[Andregewehr]

I think I made it clear, I want the sum of sales depending on the values of the accumulated minutes.

[Andregewehr]

Sorry,

For the id_product (1) and for each period, I want the following sum of sells:

- If accumulate minutes <= 10080, sum sells = 10

- If accumulate minutes <= 20160, sum sells = 22

id_product	accumulate_minutes	sum_sells
1	10080	10
1	20160	22

[Ashish_Mathur]

Hi,

Clearly show the expected result.