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:

     

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