chaserracer83
New Member
- Joined
- Oct 8, 2012
- Messages
- 27
Good morning, I am working in PowerPivot and need a column that take the value from the previous row and multiplies it by the value of another column in the same row...
<tbody>
</tbody>
I am lost about how to calculate the "Final Value" column. Any help would be greatly appreciated.
Thank you,
Chase
P.S. My company only has PowerPivot installed, so I have to accomplish this exclusively in PowerPivot without using the other Power BI tools.
Multiplier | Value | Final Value |
2% | 100 | 102 |
3% | 102*3% | |
4% | 102*3%*4% | |
5% | 102*3%*4%*5% |
<tbody>
</tbody>
I am lost about how to calculate the "Final Value" column. Any help would be greatly appreciated.
Thank you,
Chase
P.S. My company only has PowerPivot installed, so I have to accomplish this exclusively in PowerPivot without using the other Power BI tools.