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

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