Forum Discussion

BenMoses's avatar
BenMoses
New Member
2 years ago
Solved

Creating a String Array in Power BI

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...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    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's avatar
sroy_16
Icon for Resolver II rankResolver II
2 years ago

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.