Help in combining the values to a single row

[Sruthi_K]

Hello All,

I have a datasource from Jira using Powerbi connector and trying to build a report in Powerbi.

Problem is Jira issues with multiple values in a single field is showing as different row. To be clear, Jira custom field "Affected service" in a jira issue have Computer Service and Crowdstrike as Value. But instead showing comma separated "Computer Service ,Crowdstrike" its displaying as two different rows. Could someone please help how can I combine these values to a single column.

Thanks,

Sruthi

[lkalawski · Accepted solution]

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

[Uzi2019 · Accepted solution]

Hi @Sruthi_K 

simple use measure and try below formual

combine = CONCATENATEX(Fruits,Fruits[Column2],",")

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

I hope I answered your question!

[v-xuxinyi-msft · Accepted solution]

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.

[Sruthi_K]

Hi, I just dont need the entire result as a single column like Uzi2019's result.

If incident is 23879 then service should show the values in single row and the incident 23778 should dispaly as it is in the screenshot

[Uzi2019]

Hi @Sruthi_K 
Can you check my screenshot again???

As per your description it is giving the same result.

can you share the expected output with few records how you want it to be displayed??

because both of us provided the solution based on your description.

[Uzi2019 · Accepted solution]

Hi @Sruthi_K 

simple use measure and try below formual

combine = CONCATENATEX(Fruits,Fruits[Column2],",")

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

I hope I answered your question!

[lkalawski · Accepted solution]

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

[Sruthi_K]

@lkalawski Attaching the screenshot of the table, Want to merge this "Service" field as comma separated for unique issue key.

Could you please help, I'm new to Powerbi

Thanks,

Sruthi

[lkalawski]

@Sruthi_K ,

If you want to do it at the transformation level, then use my solution above.

If you want to do it at the visualization level, then the solution indicated below by Uzi2019 will work.

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