Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Please can you tell me if it's possible to have variables within a loop?
Below I am calculating Output and Net Production twice whereas I thought it would be more efficient to use variables, and re-use them.
Thank you for any help,
PW
Solved! Go to Solution.
Yes, you can use variables in a loop (iterator). Here's an example. I used the DIVIDE function instead of "/" (avoids division by 0 errors).
Output =
// loop through all customers
SUMX (
'Customers, by Fiscal Year',
VAR vOutput =
ROUND ( [Output (using calculated field)], 2 )
VAR vNetProd =
ROUND ( [Net Production (USING CALCLATED FIELD)], 2 )
RETURN
IF (
CALCULATE (
IF ( vOutput <> 0, DIVIDE ( vNetProd, vOutput ), SIGN ( vNetProd ) ),
ALL ( 'Dim_Calendar'[Fiscal Period] ),
ALL ( 'Dim_Calendar'[Fiscal Quarter] )
) < 0.39999999999,
'Calculations'[Output (using calculated field)],
0
)
)
Proud to be a Super User!
Yes, you can use variables in a loop (iterator). Here's an example. I used the DIVIDE function instead of "/" (avoids division by 0 errors).
Output =
// loop through all customers
SUMX (
'Customers, by Fiscal Year',
VAR vOutput =
ROUND ( [Output (using calculated field)], 2 )
VAR vNetProd =
ROUND ( [Net Production (USING CALCLATED FIELD)], 2 )
RETURN
IF (
CALCULATE (
IF ( vOutput <> 0, DIVIDE ( vNetProd, vOutput ), SIGN ( vNetProd ) ),
ALL ( 'Dim_Calendar'[Fiscal Period] ),
ALL ( 'Dim_Calendar'[Fiscal Quarter] )
) < 0.39999999999,
'Calculations'[Output (using calculated field)],
0
)
)
Proud to be a Super User!
User | Count |
---|---|
94 | |
87 | |
79 | |
76 | |
69 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |