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.
Hi there,
So I'm trying to merge two tables that have a similar "Event Name" column, but not all the values in the Event Name column are identical. See Table 1 and Table 2 below.
I am trying to combine these two tables so that they roll up together and give me the table that is shown below.
I have tried merging queries using a Full Outer join kind but that only joins the rows that have similar values in both tables 1 and 2. I have also tried appending the tables and then using the Group By feature and selecting All Rows under the type of operation, but this is not working either. Any ideas on how I can combine tables with a similar but not identical columns?
Thanks.
Solved! Go to Solution.
@DFoster_22
Please check the attahed file, I pasted my reply and checked the reply of @mahenkj2 , same has been suggested
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@DFoster_22
Please check the attahed file, I pasted my reply and checked the reply of @mahenkj2 , same has been suggested
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @DFoster_22 ,
I can't test now, but try as below:
For each table, at first bring A to G column in one column by unpivot function in power query.
Then append both.
And then pivot the resultant appended table.
Check if it works.
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 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |