Dear Community,
I'm trying to transfer some excel reports into Power BI reports. I have the below data with a column Date and Factor. Usually the Factor is 1, which means there are no changes in a Factor. From time to time the Factor can increase by a certain value (e.g. 1.01152...). I'm trying to create a calculated column in Power BI for the "Cumulative Factor" like I have in Excel.
In Excel this is very easy as shown in the screenshot. It's multiplying the previous cumulative value with the current Factor.
For example, the calculation on the 2/12/2024 is the following: 1.01152 * 1.01176 = 1.02342
Please help me to create the calcutated column in Power BI. Any help or suggestion is well appriciated.
Thank you very much and best regards
Zoran
| Date | Factor | Cumulative Factor |
| 1/24/2024 | 1 | 1 |
| 1/25/2024 | 1 | 1 |
| 1/26/2024 | 1 | 1 |
| 1/29/2024 | 1 | 1 |
| 1/30/2024 | 1 | 1 |
| 1/31/2024 | 1 | 1 |
| 2/1/2024 | 1 | 1 |
| 2/2/2024 | 1 | 1 |
| 2/5/2024 | 1.011523688 | 1.011523688 |
| 2/6/2024 | 1 | 1.011523688 |
| 2/7/2024 | 1 | 1.011523688 |
| 2/8/2024 | 1 | 1.011523688 |
| 2/9/2024 | 1 | 1.011523688 |
| 2/12/2024 | 1.011764706 | 1.023423966 |
| 2/13/2024 | 1 | 1.023423966 |
| 2/14/2024 | 1 | 1.023423966 |
| 2/15/2024 | 1 | 1.023423966 |
| 2/16/2024 | 1.011780105 | 1.035480008 |
| 2/19/2024 | 1 | 1.035480008 |
| 2/20/2024 | 1 | 1.035480008 |
| 2/21/2024 | 1 | 1.035480008 |
| 2/22/2024 | 1 | 1.035480008 |
| 2/23/2024 | 1 | 1.035480008 |
| 2/26/2024 | 1 | 1.035480008 |
| 2/27/2024 | 1 | 1.035480008 |
| 2/28/2024 | 1 | 1.035480008 |
| 2/29/2024 | 1 | 1.035480008 |
| 3/1/2024 | 1 | 1.035480008 |
| 3/4/2024 | 1 | 1.035480008 |
| 3/5/2024 | 1 | 1.035480008 |
| 3/6/2024 | 1 | 1.035480008 |
| 3/7/2024 | 1.010526316 | 1.046379797 |
| 3/8/2024 | 1.00591716 | 1.052571394 |
| 3/11/2024 | 1 | 1.052571394 |
| 3/12/2024 | 1 | 1.052571394 |
| 3/13/2024 | 1 | 1.052571394 |
| 3/14/2024 | 1 | 1.052571394 |
| 3/15/2024 | 1 | 1.052571394 |
| 3/18/2024 | 1 | 1.052571394 |
| 3/19/2024 | 1 | 1.052571394 |
| 3/20/2024 | 1 | 1.052571394 |
| 3/21/2024 | 1 | 1.052571394 |
| 3/22/2024 | 1.00723589 | 1.060187685 |
| 3/25/2024 | 1 | 1.060187685 |
| 3/26/2024 | 1 | 1.060187685 |
| 3/27/2024 | 1 | 1.060187685 |
| 3/28/2024 | 1 | 1.060187685 |
| 4/2/2024 | 1 | 1.060187685 |
| 4/3/2024 | 1 | 1.060187685 |
| 4/4/2024 | 1 | 1.060187685 |
In this scenario a simple PRODUCTX does the trick
Hi,
This calculated column formula works
Column = CALCULATE(PRODUCT(Data[Factor]),FILTER(Data,Data[Date]<=EARLIER(Data[Date])))Hope this helps.
In this scenario a simple PRODUCTX does the trick
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
