Forum Discussion

stefani_vileva's avatar
stefani_vileva
Icon for Resolver II rankResolver II
2 years ago
Solved

Sum of value between two dates

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 quantity20.09.202321.09.202322.09.2023
A12050110

 

Product20.09.202321.09.202322.09.2023
A120170280

 

Thank you in advance.

Kind regards,

Stefani 

  • The problem was solved only by using 

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

1 Reply

  • The problem was solved only by using 

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