Forum Discussion
Adding a loop in Power Bi
Hi Team, How does one add this loop below in power BI let start = 100; const rows = []; for (let i = 0; i < rows.length; i++) { start = start * (rows[i].priceChange + 1); } The aim o...
Could you please post sample data and desired outcome?
Sample Data:
Price change
Formula
Desired outcome
0.00
100 * (Price Change +1)
100
-0.02
100 * (Price Change +1)
98
-0.05
100 * (Price Change +1)
95
0.00
95* (Price Change +1)
95
0.01
95* (Price Change +1)
95.95
0.00
95.95* (Price Change +1)
95.95
-0.02
95.95* (Price Change +1)
94.031
so my starting formula is 100 *(price change +1), and continues until my price change = 0.00, if my price change = 0.00 then take the pervious desired outcome and substitue the 100 with the desired outcome i.e 95* (Price Change +1)
I believe my loop is as follows :
let start = 100;let price=0;const rows = [];for (let i = 0; i < rows.length; i++) {start = rows[i].priceChange === 0.00 ? desiredoutcome : start;price = start * (rows[i].priceChange + 1);}
