Help in combining the values to a single row

Hi Sruthi_K ,

Could you please share a part of table to see exactly what you habe in the column? Please copy paste two/three lines.

EDIT:

To combine values ​​from different rows, the easiest way to do it in Power Query is by using grouping.

1. Start Point

2. Group By on Column4:

3. Add Custom Column to Combine Values from Column 4 by using comma delimiter:

Text.Combine([AllRows][Column4], ", ")

4. Remove unnecessary columns and then you have the result:

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

Hi Sruthi_K 

simple use measure and try below formual

I have taken your example. getting the result as you can see..

I hope I answered your question!

Hi Sruthi_K 

Thanks for the reply from lkalawski and Uzi2019 , please allow me to share my method.

Create a measure as follows

Merged = 
CALCULATE(
    CONCATENATEX(
        VALUES('Table'[Service]),
        'Table'[Service],
        ", "
    ),
    ALLEXCEPT('Table', 'Table'[Incident])
)

Output:

Best Regards,
Yulia Xu

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