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.

 

 

  • B_Real's avatar
    B_Real
    Advocate IV
    9 years ago

     

    Measure =
Switch ( True(),
 condition1,"Result1"  ,
    condition1,"Result1"  ,
etc...                     ) 

     

    Yaas! Great shout on Switch()! I don't think I need need the True() function here tho, the Switch() function seems to take care of everything:

     

     

    SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])

     

     

    Also cheers for pointing out difference between DAX and M. Here's a link that describe the difference in more detail:

     

    http://stackoverflow.com/documentation/powerbi/6980/power-query-m-and-dax-whats-the-difference#t=201609300341275121819

     

    Essentially:

     

    First you use M to query data sources, clean and load data. Then you use DAX to analyze & visualise the data in Power BI. 

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      9 years ago

      So as a rule of thumb: :smileylol:

       

      if extract then M if transform then (if not aggregate then M else DAX) else DAX

  • Ramakrishna's avatar
    Ramakrishna
    Regular Visitor
    7 years ago

    Hi Bhaskar,

     

    can you help me with this query how to achive with DAX.

     

    IF [repair information ] = "Repeat Repair"

    THEN

    IF COUNTD([VIN]) / TOTAL(COUNTD([VIN])) > 0.1
    THEN round(COUNTD([VIN]) / TOTAL(COUNTD([VIN])),4) END

    ELSE

    IF COUNTD([Strata Claim Id]) / TOTAL(COUNTD([Strata Claim Id])) > 0.1
    THEN round(COUNTD([Strata Claim Id]) / TOTAL(COUNTD([Strata Claim Id])),4) END

    END

     

    any quick response would be appriciated.

     

    Regards,

    Ram.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I tried to use the above query but not excusted.

     

    I wanted to split the condition into the three different statement.

     

    • Avg time from purchase request[PR->DATE1] to Inquiry floated to supplier(active request)[TENDER->DATE3] (days) 
    • Avg time from {Inquiry floated to supplier}[TENDER->DATE3] to {Commercial approval done [TENDER->DATE10] (days)}
    • Average time from Commercial approval done[TENDER->DATE10] to PO issue [PO->DATE4](days).
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      For this, I think we can use a case statement how we use in SQL

  • 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"))))))

  • rpsathish3's avatar
    rpsathish3
    New Member
    6 years ago

    Thank You !