CODEWITHSUNDEEP
powerbidax
Marcola_dos_Codigo
Marcola_dos_Codigo

Reputation: 5

How do I list a column in a row in power bi?

Let's assume that i have the following: prtsc

I want to show that data in a table like that: prstc

Is there a way to do that?

Upvotes: 0

Views: 48

Answers (2)

Mark Wojciechowicz
Mark Wojciechowicz

Reputation: 4477

You can create a measure like this:

 MyMeasure = CONCATENATEX(MyTable, MyTable[Column1], "|")

Upvotes: 0

Peter
Peter

Reputation: 12345

Try this:

New Table = 
SUMMARIZE(
    'Table',
    'Table'[Column2],
    "Column1", CONCATENATEX('Table','Table'[Column1], "|")
)

enter image description here

Upvotes: 1

Related Questions