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