Multiple variables in switch statement

[jsentiscr]

Hello, I have these 2 sentences in Excel and I need to replicate it in Power BI.

Formula 1

Formula 2

Maybe someone could guide me.

Thank you.

[Greg_Deckler · Accepted solution]

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>

      ...

   )

)

[Greg_Deckler · Accepted solution]

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>

      ...

   )

)

[jsentiscr · Accepted solution]

Hi

Excellent contribution, everything worked perfectly.