ExcelToDAX
Board Regular
- Joined
- Feb 9, 2023
- Messages
- 246
- Office Version
- 365
- Platform
- Windows
I have the following Current Values in B7:D9 using the formula....
=MAKEARRAY(3, 3, LAMBDA(r,c, r*c))/10
How can I multiple each row by the previous value?
G7:I9 is what I want, but in a spilled function instead.
L7:N9 are the current formulas I have, but I would like this to be one spilled function.
=MAKEARRAY(3, 3, LAMBDA(r,c, r*c))/10
How can I multiple each row by the previous value?
G7:I9 is what I want, but in a spilled function instead.
L7:N9 are the current formulas I have, but I would like this to be one spilled function.