Forum Discussion
Solved
How to create calculated column which contain a value = current value *0.3 + previous value *0.7
Here is how I wanted my table to be, but I still can't figure out how to do it. The idea in my mind is to create a cumulative formula for this but I don't know how. Anyone have experience on this ? ...
Hi kidpk111
Attached sample file with the solutionStandarized Value = VAR CurrentTime = Data[Time] VAR CurrentIDTable = CALCULATETABLE ( Data, ALLEXCEPT ( Data, Data[ID] ) ) VAR TableOnAndBefore = FILTER ( CurrentIDTable, Data[Time] <= CurrentTime ) VAR Count1 = COUNTROWS ( TableOnAndBefore ) VAR MinTime = MINX ( TableOnAndBefore, Data[Time] ) RETURN SUMX ( TableOnAndBefore, VAR CurrentValue = Data[Test Value] VAR ThisTime = Data[Time] VAR T1 = FILTER ( TableOnAndBefore, Data[Time] <= ThisTime ) VAR Count2 = COUNTROWS ( T1 ) VAR P1 = IF ( ThisTime = MinTime, 0, 1 ) VAR P2 = Count1 - Count2 RETURN 0.3 ^ P1 * 0.7 ^ P2 * CurrentValue )
Thank you for your reply, what I don't understand is the logic behind this piece of the formula. Really appreciate your solution because it took me a lot of braincell and still can't figure it out,lol