Power BI

Needs Votes

More than two arguments in OR CONCAT and other functions.

Vote (39)

William Harding on 30 Apr 2016 01:25:03

OR, AND and CONCATENATE (and other functions) Only allow two functions. This should be considered more of a bug than a design issue as Excel and other sources all accept any number of arguments.

Comments (9)

Comments (9)

Kristjan Kure on 25 Nov 2023 19:48:05

RE: More than two arguments in OR CONCAT and other functions.

Actually you don't need this function - just use "&".[prefix] & " " & [first name] & " " & [last name]Result example: Mr. First Last

Robert Dickens on 10 Feb 2022 13:10:26

RE: More than two arguments in OR CONCAT and other functions.

Need to be fixed

Toby on 06 Jul 2020 00:01:41

RE: More than two arguments in OR CONCAT and other functions.

I can't believe they haven't fixed this yet...
Maybe in another 3 years

Sami Huq on 05 Jul 2020 23:10:16

RE: More than two arguments in OR CONCAT and other functions.

Agreed..

Zoe on 05 Jul 2020 23:00:26

RE: More than two arguments in OR CONCAT and other functions.

Why only two fields, seems a bit silly. I will now have to spend a considerable amount of time trying to nest multiple fields.

George Maher on 05 Jul 2020 22:34:06

RE: More than two arguments in OR CONCAT and other functions.

Strange that you cannot have a list of functions in the AND statement. Don't know of any other language that has this limit.

David Hager on 05 Jul 2020 22:33:21

RE: More than two arguments in OR CONCAT and other functions.

Create a DAX function that works like the Excel TEXTJOIN function.

Hera on 05 Jul 2020 22:30:33

RE: More than two arguments in OR CONCAT and other functions.

a serious problem in not accepting more than 2 in a OR statement! Please fix this issue in next update.

Power BI User on 05 Jul 2020 22:22:39

RE: More than two arguments in OR CONCAT and other functions.

fully agree