Previous Row Cell multiplied with This Row Cell
This is my first post in this Community. I have been struggling for a week on what is a basic calculation in Excel, but in PowerBI/DAX a different animal. I am trying to... 1. reference the previous cell (1 in DiscFactorUnsec) below and multiply with (2) to get (3) and repeat that for each row i.e. by 2. then use (3) to multiply with third row in DiscFactorUnsec (0,9456) to get (4 (in DFPrev4)) and so on as shown in the first 4 rows of DFPrev4 (correct up to (5 - Row 4) - Row 6 is wrong) I think the problem might be to make an intermediate calculation to hold the previous product and multiply with present row's DiscFactorUnsec value and then again hold that value until the next row's calculation and so on. Any suggestion for a solution would be greatly appreciated.
