Cummulative sales from most sold to least sold product filtering by a selected period

[alexrf86]

Hi! I am trying to acummulate my sales from the most sold to the least sold product for a specific selected period. Data Table has this structure: --> Date, Product, Sales.

For instance,

Date	Prod	Sales
01/01/2020	k2	3
01/01/2020	a1	4
01/01/2020	b5	10
02/01/2020	k2	1
02/01/2020	a1	2
02/01/2020	b5	3
03/01/2020	k2	2
03/01/2020	a1	3
03/01/2020	b5	4
04/01/2020	b5	1
04/01/2020	a1	1

So, If my desired result was the acummulative sales from the most sold product to the least sold product for the period 02/01/2020 to 03/01/2020, I should get this table:

b5	7
a1	12
k2	15

This is because product sales during this period have been:

k2	3
b5	7
a1	5

So if I ordered sales products from most sold to least sold:

b5	7
a1	5
k2	3

Finally, product cummulating sales:

b5	7
a1	12
k2	15

If the Data Table did not contain Date, this measure would cummalate sales properly from most sold to least sold:

Cummulative_sales = CALCULATE(sum(table[sales]), FILTER(all(table),table[sales]>=MAX(table[sales])))

However I need to include Date in Data Table to be able to filter the period I need to acummulate sales.

May anyone help me please?

[amitchandak]

@alexrf86 , I doubt you can get this order.

Please check quick measure  there is an option for running/cumulative total try that

[alexrf86]

@amitchandak  Order is not a problem. I can add a column with the total Sales per product and use this column to order. For example:

Product	Period Sales	Cummulate Sales
b5	7	7
a1	5	12
k2	3	15

My issue is how to create a Cummulate Sales measure choosing a specific date period (not from the beginning of my calendar)