Forum Discussion

ccsrtw's avatar
ccsrtw
Advocate I
9 years ago
Solved

power query - group/pivot

I have a table with two columns:   ID                                        Product   006F000000bqOUHIA2 Apple 006F000000bqosaIAAB Banana 006F000000dqoLdIAI Pear       There ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    ccsrtw

     

    Hi, A alternative in DAX:

     

    Create a New Table(from Modeling) and use this:

     

    Table =
SUMMARIZECOLUMNS (
    Table1[ID],
    "FruitList", CONCATENATEX ( Table1, Table1[Fruit], "," )
)

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

ccsrtw

 

Hi, A alternative in DAX:

 

Create a New Table(from Modeling) and use this:

 

Table =
SUMMARIZECOLUMNS (
    Table1[ID],
    "FruitList", CONCATENATEX ( Table1, Table1[Fruit], "," )
)

 

ccsrtw's avatar
ccsrtw
Advocate I
9 years ago

That gets it done, thanks!