Merge rows based on criteria

[CG12]

Hello folks,

So I am trying to figure a way in my dataset in which I can combine/merge two rows together based on similar identifier or criteria in Powerbi. For example in the case below, what I want to achieve is, I want anything of this particular "Type" to merge together but not the others. 

Is this possible? Even using a query?

Thanks for your help in advance

[v-xicai · Accepted solution]

Hi @CG12 ,

You can create calculated table using DAX below.

NewTable = ADDCOLUMNS(

    SUMMARIZE(

        Table1,

        Table1[Customer ID],Table1[question ID],Table1[Type]

    ),

    "Values",

    CALCULATE(

        CONCATENATEX(Table1, Table1[Answer], ", ")

    )

)

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CG12]

Worked like a charm! Thank you thank you!!!!