Sum of value between two dates

stefani_vileva — Tue, 26 Sep 2023 06:23:48 GMT

Hello everyone,

I want to calculate the total quantity between two dates, the problem is that all of the time I get only the sum of the current day shown in the column

CALCULATE(SUM(Sales[Quantity(KG)]), DATESBETWEEN('Sales'[Date], MINX(ALL('Date'[Date]), 'Date'[Date]), MAX(Sales[Date])))

I want to show this value in a matrix form where as rows I have products, and the columns are dates, for example

the data in the source file would be

Product quantity	20.09.2023	21.09.2023	22.09.2023
A	120	50	110

Product	20.09.2023	21.09.2023	22.09.2023
A	120	170	280

Thank you in advance.

Kind regards,

Stefani

Re: Sum of value between two dates

stefani_vileva — Tue, 26 Sep 2023 06:46:54 GMT

The problem was solved only by using

CALCULATE(SUM(Sales[Quantity(KG)]), 'Date'[Date] <= MAX(Sales[Date]))

topic Re: Sum of value between two dates in DAX Commands and Tips

Sum of value between two dates

Re: Sum of value between two dates