More than two arguments in OR CONCAT and other functions.

[billh]

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.

[Emamnuel_blum]

fully agree

[heramiah]

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

[dhExcel]

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

[georgemaher]

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

[zoe_johansson]

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

[huq_sami1]

Agreed..

[toby8]

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

[rdicke1]

Need to be fixed

[fbcideas_migusr]

Actually you don't need this function - just use "&".

[prefix] & " " & [first name] & " " & [last name]

Result example: Mr. First Last