Forum Discussion
Solved
Iterator function with too many calculations
Hi I am trying to migrate an Excel scenario modelling tool into Power BI. The Excel spreadsheet has a small table of data: ~40 rows and ~100 columns and there are ~40 scenario modelling inputs. ...
Calc4 =
AVERAGEX(
'Table1',
VAR _d='Table1'[Raw Data 1] * (1 + [parameter1]) VAR _e='Table1'[Raw Data 2] * (1 + [parameter2]) VAR _f=_e/_d VAR _g=_d+_f RETURN _g)
'Table1'[Raw Data 1] * (1 + [parameter1]))
Calc4 =
AVERAGEX(
'Table1',
VAR _d='Table1'[Raw Data 1] * (1 + [parameter1]) VAR _e='Table1'[Raw Data 2] * (1 + [parameter2]) VAR _f=_e/_d VAR _g=_d+_f RETURN _g)
'Table1'[Raw Data 1] * (1 + [parameter1]))
That is amazing! Thank you so much. I never thought I could use VAR inside the AVERAGEX
