title: PowerBi Join column value strings together in each row
body: <p>I have a table like shown below titled Employees:</p>
  <pre><code>Name     LOC1     LOC2     LOC3     LOC4
  -----------------------------------------
  Joe      DAY      CVG      DTW
  Jane     PVD      STL  
  John     LAX      SAN      SFO      ANC
  </code></pre>
  <p>I created a measure to combine the LOC fields into 1 result separated by a space.  I keep getting errors because PBi wants to aggregate the data fields.  All fields are type Text.  I've tried all the usual combine methods, below are a couple of examples...</p>
  <pre><code>CombineLOCs=CONCATENATE('Employees'[LOC1],'Employees'[LOC2])
  
  CombineLOCs= 'Employees'[LOC1] &amp; &quot; &quot; &amp; 'Employees&quot;[LOC2]
  </code></pre>
  <p>This is what I get back:
  <a href="https://i.stack.imgur.com/C54he.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/C54he.png" alt="enter image description here" /></a></p>
  <p>&quot;A single value for column 'LOC1' in table 'Employees' cannot be determined.  This can happen when a measure formula refers to a column that contains many values without specifying an aggregation....etc.&quot;</p>
  <p>I ultimately have a table visual on my canvas and instead of listing out all of the columns on that table, I just want 1 column with all of the combined LOC values for each employee in it.</p>