Merge rows contain different values

[Kid_Koala]

I've got a problem with merging some rows. Bad issue with geting data brings me two different rows, (which are really the one) contains two part of information.

For instance, this one. Here you can see two rows representing data on the one single ad campaing. The first row contains stats for clicks, costs and everithing except goal converstions. The second one is showing just conversions. I want to merge them in Power Bi, as I can't solve the issue with the correct data getting. 

Could someone help? Thanks.

[v-yulgu-msft · Accepted solution]

Hi @Kid_Koala,

You may try CONCATENATEX Function.

Regards,

Yuliana Gu

[stretcharm]

You could do this a few ways.

I would start by creating a key by using split delimeter right most | on campaign.

You can then create two references for the 2 types of row. Filtering each with the 2nd part of the split.

Finally merge them together again with the key and expand the 2nd tables columns.