'Show previous nonblank/non-zero value from rows
I am working in PowerBI, and I would like to ask you for help with following issue:
I have weekly data and I want to show data from previous week/row is separate column. I was able to do that, but I have problem with blank/zero values.
Instead of zero I would like to use previous non-zero/non-blank value - so, the goal is to have columns: value and highlighted column (see below).
Thank you
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|