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