cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Sum based on accumulated values

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

3 REPLIES 3
Helper I

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

Helper I

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

Super User

Hi,

Clearly show the expected result.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.