Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
4 years ago
Solved

Concatenate single column

Hi all,   I want to concatenate all values in a column with " prefix and suffix and ,   Example: Column1 3000 2000 7777   I want result to be:  "3000", "2000", "7777"   I will be using th...
Need Help
  • mb0307's avatar
    mb0307
    4 years ago

    Found solution:

     

     

         {Cube.ApplyParameter, "[!V99]", {"""" & Text.Combine(TableName[ColName],""", """) & """" }}

     

mb0307's avatar
mb0307
Responsive Resident
4 years ago

Found solution:

 

 

     {Cube.ApplyParameter, "[!V99]", {"""" & Text.Combine(TableName[ColName],""", """) & """" }}