Creating a String Array in Power BI

[BenMoses]

Hi, 

I got 3 differenet columns and I want to create a String Array for them and I want them into a table

Ex:

Cars	Model	Color
Honda	Civic	White
Mazda	CX9	Black
Toyota	Camry	Red

I'm not sure about the String function that needed to be used! 

Thank you!

[danextian · Accepted solution]

Hi @BenMoses ,

You can use COMBINEVALUES to concatenate those columns

You can also use & sign but this will result to a more verbose formula

[sroy_16]

Create a custom column in the Power Query and add this M code.
= "[" & Text.From([Cars]) & ", " & Text.From([Model]) & ", " & Text.From([Color]) & "]".
This should help you achieve the output you are looking for.

Let me know if this works.

[qqqqqwwwweeerrr]

Hi @BenMoses 

can you please share expected output?

Regards

[BenMoses]

formatted String ["Car", "Model", "Color"]

Thank you