A common expression most database developers are familiar with CONCATENATE. It combines text data from multiple columns and represents it as a single string. Similar to CALENDAR Concatenate isn’t really a measure that can be dragged and dropped instead it is added as a calculated column within the PowerPivot Interface. As shown below
The end result looks as shown below
As can be seen from the above screenshots a severe limitation of CONCATENATE is that it can accept only two inputs at a time. Here we use Concatenate to generate a string for STATE +”|”+CITY format.
The SQL Equivalent is