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
asmagh
Helper I
Helper I

Multiple condition in if

hello , please i need some help here what i have 
if ( ca = 0 ) in date1 and ca <>0 in date2 then 'new' 

else if ( ca in date1 < ca in date2 ) then 'up')

else if (ca in date 1 > ca in date then 'down')

else if ca <> 0  in date1 and ca = 0 in date 2 then 'unkhnown')

 

so i try to write it with dax like this    

if ( (ca=0 , date1 ), 'nouveaux' , if(ca <>0 , date2), 'nouveaux', if ((ca , date1 )<(ca , date2), 'croissance', if ((ca , date1 )>(ca , date2), 'perte',if((ca<>0 , date1 ), (ca =0 , date2),'null'))))) 

or 

if ( (ca=0 , date1 ) && (ca <>0 , date2); 'nouveaux';  if ((ca , date1 )<(ca , date2); 'croissance'; if ((ca , date1 )>(ca , date2) ; 'perte' ; if((ca<>0 , date1 )&&(ca =0 , date2);'null')))))


I have a problem to acces to power BI so until i found a solution i want to be sure that my dax querry is right .
Any suggestion please 
thank you 

1 ACCEPTED SOLUTION
Floriankx
Solution Sage
Solution Sage

Hello, Switch should be perfect.

 

I assume two measures,

CA1 for ca in date1 and CA2 for ca in date2.

 

Switch(
TRUE(),
[CA1]=0 && [CA2]<>0, 'new', --condition 1
[CA1]>[CA2], 'up', --condition 2
[CA1]<[CA2], 'down' --condition 3
[CA1]<>0 && [CA2]=0, 'unknown' --condition 4
BLANK()) --else

For further information check this article.

 

I hope this helps. I want miss the SWITCH function anymore.

View solution in original post

14 REPLIES 14

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.