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.
This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.
