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

     

     

     

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Icon for Solution Sage rankSolution Sage
2 years ago

Hi BenMoses 

 

can you please share expected output?

 

Regards

BenMoses's avatar
BenMoses
New Member
2 years ago

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

Thank you