Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I wonder if someone can help me to make this code shorter? It works perfectly , buy I need to review it and it's hard to understand when there is so much text.
SLA FORM OTC = IF('SNOW(sn_sm_finance_request)'[priority] = "1 - Critical" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Front Office Spain" || 'SNOW(sn_sm_finance_request)'[priority] = "1 - Critical" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Shared Service Center"; "0,4"; IF('SNOW(sn_sm_finance_request)'[priority] = "2 - High" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Front Office Spain" || 'SNOW(sn_sm_finance_request)'[priority] = "2 - High" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Shared Service Center"; "0,8"; IF('SNOW(sn_sm_finance_request)'[priority] = "3 - Moderate" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Front Office Spain" || 'SNOW(sn_sm_finance_request)'[priority] = "3 - Moderate" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Shared Service Center"; "3"; IF('SNOW(sn_sm_finance_request)'[priority] = "4 - Low" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Front Office Spain" || 'SNOW(sn_sm_finance_request)'[priority] = "4 - Low" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Shared Service Center"; "3"; IF('SNOW(sn_sm_finance_request)'[priority] = "" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Front Office Spain" || 'SNOW(sn_sm_finance_request)'[priority] = "" && 'SNOW(sn_sm_finance_request)'[assignment_group]= "FSM OTC Shared Service Center";"3"; "" )))))
Regards
Albin
Solved! Go to Solution.
Hi Albin,
This is a calculated column by the looks of it.
I would suggest declaring some variables and using the SWITCH function.
Here is one way of doing it where I have stored almost every column value and constant in a variable. The SWITCH function replaces most of the nested IFs. I have also simplified the expression of the logical tests.
SLA FORM OTC = VAR P = 'SNOW(sn_sm_finance_request)'[priority] VAR AG = 'SNOW(sn_sm_finance_request)'[assignment_group] VAR Spain = "FSM OTC Front Office Spain" VAR Shared = "FSM OTC Shared Service Center" VAR Spain_Shared = { Spain; Shared } VAR P1 = "1 - Critical" VAR P2 = "2 - High" VAR P3 = "3 - Moderate" VAR P4 = "4 - Low" VAR PBlank = "" RETURN IF ( AG IN Spain_Shared; SWITCH (
P;
P1; "0.4";
P2; "0.8";
P3; "3";
P4; "3";
PBlank; "3";
""
); "" )
Can you confirm this still works?
Regards,
Owen
Hi Albin,
This is a calculated column by the looks of it.
I would suggest declaring some variables and using the SWITCH function.
Here is one way of doing it where I have stored almost every column value and constant in a variable. The SWITCH function replaces most of the nested IFs. I have also simplified the expression of the logical tests.
SLA FORM OTC = VAR P = 'SNOW(sn_sm_finance_request)'[priority] VAR AG = 'SNOW(sn_sm_finance_request)'[assignment_group] VAR Spain = "FSM OTC Front Office Spain" VAR Shared = "FSM OTC Shared Service Center" VAR Spain_Shared = { Spain; Shared } VAR P1 = "1 - Critical" VAR P2 = "2 - High" VAR P3 = "3 - Moderate" VAR P4 = "4 - Low" VAR PBlank = "" RETURN IF ( AG IN Spain_Shared; SWITCH (
P;
P1; "0.4";
P2; "0.8";
P3; "3";
P4; "3";
PBlank; "3";
""
); "" )
Can you confirm this still works?
Regards,
Owen
Hi,
Thank you very much!
It work great.
Regards
Albin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |