topic Re: Cummulative calculation (add indexing price) per day in DAX Commands and Tips

Cummulative calculation (add indexing price) per day

BasN — Fri, 19 Jan 2024 20:36:44 GMT

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?

Re: Cummulative calculation (add indexing price) per day

AlexisOlson — Fri, 19 Jan 2024 21:26:54 GMT

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]

Re: Cummulative calculation (add indexing price) per day

BasN — Sat, 20 Jan 2024 21:01:01 GMT

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