Please help me with my problem that is simply made in Excel but not in PowerBI. At least, I am struggling to make this work in PowerBI.
In the excel file, there is a table. In column “D” there are two formulas.
- The formula in cell “D2” contains value 100.
- The formula in cells greater that “D2” contains formula = D2*(1+E3).
I want to replicate the table`s calculation in PowerBI but I have been struggling to make it work almost two days. Please help, see attached the excel file with an example of how should the PowerBI measure work.
Replicate this.xlsx (9.4 KB)