cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Merge rows contain different values

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. 

example.png


Could someone help? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Merge rows contain different values

Hi @Kid_Koala,

 

You may try CONCATENATEX Function.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Memorable Member
Memorable Member

Re: Merge rows contain different values

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.

 

 

Highlighted
Microsoft
Microsoft

Re: Merge rows contain different values

Hi @Kid_Koala,

 

You may try CONCATENATEX Function.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors