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.

     

     

B_Real's avatar
B_Real
Advocate IV
9 years ago

Update. 

 

'If then else' is possible in Power BI, but not using freehand DAX. It only seems to be available using menus, like so:

 

Go to Edit Queries

 

 

Then Add Column -> Conditional Column

 

 

Et voila.... your if then else statements are available...

 

 

I'm still not sure why you can't just type these freehand in the DAX editor to save you all that menu work.

 

 

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    B_Real when editing queries you are not in the DAX environment, but in M (a.k.a. Power Query).

    These are completely different: Power Query is aimed at getting and transforming data into tables, while DAX is mainly focussed on aggregating data into measures.

    However, some tasks can be done in both environments and both environments reside in Power BI..