Forum Discussion

B_Real's avatar
B_Real
Advocate IV
9 years ago
Solved

if then else

Most languages have a structure that allows multiple conditions to be met in an IF statement, like this:   IF condition1 THEN result1 Else If condition2 THEN result2 ELSE result3.   Except for DA...
Tips and Tricks
  • Baskar's avatar
    Baskar
    9 years ago

    Cool my dear friend.

     

    We can do anything in DAX cool.

     

    Try this,

     

    Measure =

    Switch ( True(),

     condition1,"Result1"  ,

        condition1,"Result1"  ,

    etc...                     ) 

     

     

    let me if any help in DAX.

     

     

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Cool my dear friend.

 

We can do anything in DAX cool.

 

Try this,

 

Measure =

Switch ( True(),

 condition1,"Result1"  ,

    condition1,"Result1"  ,

etc...                     ) 

 

 

let me if any help in DAX.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Baskar

 

I am trying to write this if statement in dax but i am not getting the result can you please help me out

 

Forecast Category II = IF(DSAPJ_Opportunity[Forecast Category]="Open",IF((DSAPJ_Opportunity[Forecast Category]="Pipeline" & DSAPJ_Opportunity[Sales Stage1] IN {"01","02","03","04A","04B","05","06"},"Pipeline",IF(DSAPJ_Opportunity[Forecast Category]="Upside" & DSAPJ_Opportunity[Sales Stage1] IN {"04A","04B","05"},"Upside",IF(DSAPJ_Opportunity[Forecast Category]="Commit" & DSAPJ_Opportunity[Sales Stage1] IN {"04A","04B","05"},"Commit",IF(DSAPJ_Opportunity[Forecast Category]="Won" & DSAPJ_Opportunity[Sales Stage1] = "06" , "Won","DQ Issues"))))))