Cummulative calculation (add indexing price) per day

[BasN]

Hello,

The idea is to cummulative multiply the index per day (in the left table) with the Deal Price with the days between StartDate and EndDate (this is a reference date).
So that you get a new column in the right table with the name "Indexed Deal Price on reference date". Is this possible?

[AlexisOlson · Accepted solution]

Is this what you mean?

Indexed Deal Price on reference date =
VAR _Start = RightTable[StartDate]
VAR _End = RightTable[EndDate]
VAR _FilterLeft_ =
    FILTER (
        LeftTable,
        LeftTable[Dates] >= _Start
            && LeftTable[Dates] <= _End
    )
VAR _Product =
    PRODUCTX (
        _FilterLeft_,
        1 + LeftTable[Index per day]
    )
RETURN
    _Product * RightTable[Deal Price]

[BasN]

Thank you very much Alexis, I think this is what I was looking for!