DAX formula to concatenate three columns

concatenation ssas dax
user2107971 picture user2107971 · Mar 4, 2014 · Viewed 38.8k times · Source

I am mew to DAX. How can I concatenate three different columns say First_Name, Middle_Name and Last_Name to a single column with a space in between using CONCATENATE function in DAX. At present I could concatenate only two columns.

=CONCATENATE(FIRST_NAME],CONCATENATE(" ",[LAST_NAME]))

If any other function is there please do let me know that also. My aim is to concatenate 1st Name, 2nd Name and 3rd Name into a single column in SSAS Tabular Model

Please help me. Thanks in Advance

Answer

FrankPl picture FrankPl · Mar 4, 2014

If the columns are already text, you can use th & operator, i. e. use

[FIRST_NAME] & " " & [LAST_NAME]

You can find the documentation of concatenate - including the fact that it only accepts two arguments - at http://technet.microsoft.com/en-us/library/ee634811.aspx.

Related questions

How do I concatenate two lists in Python?

How do I concatenate two lists in Python? Example: listone = [1, 2, 3] listtwo = [4, 5, 6] Expected outcome: >>> joinedlist [1, 2, 3, 4, 5, 6]

Read More
How to concatenate items in a list to a single string?

Is there a simpler way to concatenate string items in a list into a single string? Can I use the str.join() function? E.g. this is the input ['this','is','a','sentence'] and this is the desired output this-is-a-sentence …

Read More
Getting current date and time in JavaScript

I have a script that prints the current date and time in JavaScript, but the DATE is always wrong. Here is the code: var currentdate = new Date(); var datetime = "Last Sync: " + currentdate.getDay() + "/" + currentdate.getMonth() + "/" + currentdate.getFullYear() + " @ " + currentdate.getHours() + ":" + currentdate.…

Read More