Forum Discussion
Multiple variables in switch statement
Most IF statements will translate pretty well between Excel and Power BI because they have the same syntax. Now, your COUNTIF won't because that function doesn't exist, you need to use CALCULATE OR COUNTX.
The other part I anticipate issues is with your AND statements as the DAX versions only accept two arguments versus Excel it is a list. I would suggest using && for AND And || for OR instead.
My suggestion would be to use the SWITCH(TRUE()...) trick like this, I'll start you off:
Formula 1 =
IF([@RESPONSABLE]="REACTIVO",
SWITCH(TRUE(),
[@CATEGORIA]="DX - CUENTE" && [@SUBFALLA] = "CONEXIONES" && [@SUB SUBFALLA] = "CUENTE ...","EXCLUSIONES",
<next true/false>,<next result>
...
)
)
Hi
Excellent contribution, everything worked perfectly.
Most IF statements will translate pretty well between Excel and Power BI because they have the same syntax. Now, your COUNTIF won't because that function doesn't exist, you need to use CALCULATE OR COUNTX.
The other part I anticipate issues is with your AND statements as the DAX versions only accept two arguments versus Excel it is a list. I would suggest using && for AND And || for OR instead.
My suggestion would be to use the SWITCH(TRUE()...) trick like this, I'll start you off:
Formula 1 =
IF([@RESPONSABLE]="REACTIVO",
SWITCH(TRUE(),
[@CATEGORIA]="DX - CUENTE" && [@SUBFALLA] = "CONEXIONES" && [@SUB SUBFALLA] = "CUENTE ...","EXCLUSIONES",
<next true/false>,<next result>
...
)
)
Hi
Excellent contribution, everything worked perfectly.