Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jsentiscr
Regular Visitor

Multiple variables in switch statement

 

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

 

Formula 1

 

F1.PNG

 

Formula 2

 

 

F2.PNG

 

Maybe someone could guide me.

 

Thank you.

 

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

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>

      ...

   )

)

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

 

Hi

 

Excellent contribution, everything worked perfectly.

 

F1.PNG

 

 

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

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>

      ...

   )

)

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

 

Hi

 

Excellent contribution, everything worked perfectly.

 

F1.PNG

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.