Forum Discussion

DerMainzer's avatar
DerMainzer
Icon for Resolver I rankResolver I
3 years ago
Solved

two or more IF conditions

Hi   I'm an absolute Noob and just started learning so please excuse me if my search through the different articles didn't bring me the solution.   I don't get the IF AND   or   IF && syntax, Nei...
Need Help
  • DerMainzer's avatar
    DerMainzer
    3 years ago

    EDIT: in Power Query I've made it now that way as an example:

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi, 

I am not sure if I understood your question correctly, but please try something like below.

It is for creating a calculated column.

 

Expected result Calculated Column: =
SWITCH (
    TRUE (),
    Persons[Age] > 10
        && Persons[Age] <= 20, "BETWEEN 10-20",
    Persons[Age] > 20
        && Persons[Age] <= 30, "BETWEEN 20-30",
    Persons[Age] > 30
        && Persons[Age] <= 40, "BETWEEN 30-40"
)
DerMainzer's avatar
DerMainzer
Icon for Resolver I rankResolver I
3 years ago

Hi, 

thanks for the quick response but I get the same error as above. Let me try to explain it better:

 

My goal is to be able to add a new coloumn via Power Query OR via a measure! I'm in the learning phase and just started with power BI.

 

Power Query: I want to add a custom coloum to my table:

But PQ doesn't know what SWITCH is!

 

Also I want to be able to add a new coloumn via a meassure but I think in the statement is something missing lik ADDCOLOUMN.

 

Sorry, I can't explain it better.

 

Regards,

 

Tim

 

  • JirkaZ's avatar
    JirkaZ
    Icon for Solution Specialist rankSolution Specialist
    3 years ago

    The SWITCH() function is a DAX function - therefore will not work in Power Query, but it will work when creating a calculated column in the report engine. 

    If you want to use Power Query, then you'll have to use multiple embedded if then else statements