Long decision making trees using if then else ?

[Anonymous]

Hi PowerBI experts,

I have a simple yet important and practical question:

What is the best way to calculate a new column based on a number of if conditions? Please see the code below - this is based on a long tree decision making.
It works fine but its ugly and not good for maintenance. What is the way to calculate this column guys?


My_New_Col =
IF(LEN([ColA])=0;
IF(ISBLANK([ColB]);
IF(LEN([ColC])=0;
IF([ColD]="Open");
[ColE];
IF(LEN([ColF])=0;
IF(LEN([ColG])=0;
"Missing Data";
[ColG]);
RELATED('Table_more_data'[ColF])));
[ColC];

IF(CONTAINSSTRING(RELATED('Table_more_data2'[ColA]);"xyz");"Waiting";"No deal"));
[ColA]
)

Thanks in advance for your help. Keep up the good work!
Comment: LEN and ISBLANK is used because of int and string columns

[Greg_Deckler · Accepted solution]

Holy cow, use SWITCH(TRUE()...)

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can refer to this blog:https://community.powerbi.com/t5/Community-Blog/SWITCH-True-Logic-In-Power-BI-What-s-Possible-With-This/ba-p/509753 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

Holy cow, use SWITCH(TRUE()...)