SUM with different Date Ranges

[AjosefMD]

Dear Community,

I need to sum (total) Quantities with different Date-Ranges. 

In the yellow example I need for Date "06.10.2020" the sum of all Quantities between 06.10.2020 and 15.12.2020. Same for e.g. green. I need sum of Quantities between "30.11.2020" and "08.02.2021".

Maybe you have a working solution for me.

Thank you,
Josef

[Taoufiq_Zarra]

@AjosefMD  like ?

Sum({<Date={"$(= '>=' & '06.10.2020' & '<=' & '15.12.2020')"}>} Quantity)

and

Sum({<Date={"$(= '>=' & '30.11.2020' & '<=' & '08.02.2021')"}>} Quantity)

[AjosefMD]

Yes, but the Date Range needs to be calculated new for each row and each Start-/EndDates. So I can not enter fix Dates like this.

[Vegar · Accepted solution]

It looks like your intervals are static, what if you use intervalmatch() to solve this this problem?

LOAD
    Material,
    Date,
    Quantity
FROM SOURCE;

IntervalMatch (Date)
LOAD
    StartDate,
    EndDate
FROM SOURCE;

[AjosefMD]

Thank you very much! It works perfect :).