When we need to concatenate two strings into one in Power BI, the first option that comes to mind is CONCATENATE or CONCATENATEX. While CONCATENATE works with columnar based structure, CONCATENATEX is an iterator function, needing a table to iterate row by row. But actually, we have a new player in the game since 2017 and it is called COMBINEVALUES. Hence it's a relatively new function, it's not used as much as the others, and that's why I have decided to write a post about it. First let's try to concatenate without using any function, only with the ampersand operator. And this is the output : As you see it's pretty simple, there is no room for surprise. Before doing the same thing with CONCATENATE, let's check the syntax first: CONCATENATE(<text1>, <text2>) A s you see, it accepts only two arguments. To concatenate multiple columns we can either write the function with the ampersand operator (&) a...
A blog about solving the problems that we face, while we're creating Power BI reports.