Forum Discussion

Elios's avatar
Elios
Regular Visitor
5 years ago
Solved

Convert Excel functions to DAX

Hello there,   I am a new user of power BI, I have quite the complex formula in excel that return conditional values. I tried to put it in Power BI however the error: "Too many arguments were pass...
General Comment
Need Help
Tutorial Requests
  • nandic's avatar
    nandic
    5 years ago

    Elios , parry2k  mentioned below matching syntax:

    || -> OR

    && -> AND
    You can use OR/AND when you compare 2 arguments, and you should use 

    || / && when having more than 2 arguments

nandic's avatar
nandic
Resident Rockstar
5 years ago

Hi Elios ,
It seems your are passing multiple conditions to OR function? OR function accepts only 2 parameters.
If you need multiple conditions in OR function, use this syntax:
If(Table[Criteria1] = "A" || Table[Criteria2] = "B" || Table[Criteria3] = "C" || ...

Regards,
Nemanja Andic

Elios's avatar
Elios
Regular Visitor
5 years ago

Thank you that seems to be what I need, what are the || ? Do they play a similar role to the OR function ?

 

Also I have a similar problem with the AND function that is less flexible than on excel. Do you have any idea how to replace it with something that can accept more than 2 parameters ?

  • nandic's avatar
    nandic
    Resident Rockstar
    5 years ago

    Elios , parry2k  mentioned below matching syntax:

    || -> OR

    && -> AND
    You can use OR/AND when you compare 2 arguments, and you should use 

    || / && when having more than 2 arguments