Forum Discussion
How to get value from previous row in current calculated column
- 3 years ago
Hi Anonymous
If B is a calculated column thenB = SUMX ( FILTER ( 'Table', 'Table'[Index] <= EARLIER ( 'Table'[Index] ) ), 'Table'[A] ) - 3 years ago
Hi Anonymous
Please refer to attached sample file with the proposed solutionB = COALESCE ( DIVIDE ( 1, PRODUCTX ( FILTER ( 'Table', 'Table'[Index] <= EARLIER ( 'Table'[Index] ) && 'Table'[Index] > 1 ), ( 1 + 'Table'[A] ) ^ (1/16) ) ), 1 )The numbers do not 100% match yours, but when I made the my own excel sample file, the numbers were 100% matching. Could it be a rounding error?
- 3 years ago
Anonymous
Value = COALESCE ( PRODUCTX ( FILTER ( Table2, Table2[Index] <= EARLIER ( Table2[Index] ) && Table2[Index] > 1 ), 1 + Table2[A] ) * 100, 100 )
Hi Anonymous
If B is a calculated column then
B =
SUMX (
FILTER ( 'Table', 'Table'[Index] <= EARLIER ( 'Table'[Index] ) ),
'Table'[A]
)- Anonymous3 years agoNot applicable
That did work fine. What if I want to expand the complexity by the following, knowing that B1 = 1,
- tamerj13 years agoCommunity Champion
Anonymous
Ya that is pretty complex. I'll have a look at it tomorrow.
- tamerj13 years agoCommunity Champion
Hi Anonymous
Please refer to attached sample file with the proposed solutionB = COALESCE ( DIVIDE ( 1, PRODUCTX ( FILTER ( 'Table', 'Table'[Index] <= EARLIER ( 'Table'[Index] ) && 'Table'[Index] > 1 ), ( 1 + 'Table'[A] ) ^ (1/16) ) ), 1 )The numbers do not 100% match yours, but when I made the my own excel sample file, the numbers were 100% matching. Could it be a rounding error?
- Anonymous3 years agoNot applicable
Amazing, and thank you so much for solving my issue! ❤️