Power BI

New

More than two arguments in OR CONCAT and other functions.

Vote (37)

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 (7)

Comments (7)

9c20e9ea b708-4290-8670-aefd7773f45e 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

c08544c6 dd51-4ed1-9b0f-9305afc207c9 on 05 Jul 2020 23:10:16

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

Agreed..

c4439f19 9722-4e45-8a19-dd324f9f5dd4 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.

08bf8603 ed45-4468-aed8-04e42422f802 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.

9afa0911 8de3-4272-918b-798eb4508ac8 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.

9db4f72f f8d3-4f54-b918-80e3f222531b 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.

7d4d68c8 f82d-4aec-a762-dca800d5689f on 05 Jul 2020 22:22:39

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

fully agree