Forum Discussion
How to get previous value in a matrix
Hello Power BI Community,
I badly need help on my dashboard, I need to;
Row 0, 2.05%, 97.95%
Row 1, 2.05%, (1-2.05%)*prev_row (97.95%)
result: Row 1, 2.05%, 95.94%
Hope anyone can help.
Thank you very much
3 Replies
bshefferContinued Contributor
try dax offset function
The previous row is a calculated measure.
- bsheffer
of course if the row values are actual values in a table you can just put that value in a variable and add that to the filter of the calculate to get the value you want for the prior row
prior row = row - 1
