Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Kid_Koala,
You may try CONCATENATEX Function.
Regards,
Yuliana Gu
Hi @Kid_Koala,
You may try CONCATENATEX Function.
Regards,
Yuliana Gu
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |