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

AlexisOlson  Thanks

 

My column is Text already so used _ instead.

 

But I get this error:

 

Code:

{Cube.ApplyParameter, "[!V99]", {{ Text.Combine(List.Transform( ForBW[Last Friday of Month], each """" & _ & """"), ",") }}},

 

Thanks

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

I think you have an extra set of {} here. Can you check if this works?

{Cube.ApplyParameter, "[!V99]", { Text.Combine(List.Transform( ForBW[Last Friday of Month], each """" & _ & """"), ",") }},