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,
I want to combine a N or Y column in a table called AIP, with a N or Y column in a table called OIP to make 1 pie chart that shows N or Y overall
Solved! Go to Solution.
Hi @Anonymous ,
= Table.Combine({AIP, OIP})
In Power Query, the above is the code to append two or more tables.
I started with two dissimiliar tables, combined the two and created a new table. I used the Power Query Append Queries as New.
Power Query used null for the data in unshared columns.
Then you could delete any columns you don't need by selecting the columns you do need, and Delete Columns Other.
Probably easier and quicker. No duplication required.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hey Guys,
Thanks for the reply. I just duplicated both tables deleted all other columns and left the N,Y columns, then appended to a new table. I was hoping to find a code to just create a table that would append the column without having to duplicate and then append.
Hi @Anonymous ,
= Table.Combine({AIP, OIP})
In Power Query, the above is the code to append two or more tables.
I started with two dissimiliar tables, combined the two and created a new table. I used the Power Query Append Queries as New.
Power Query used null for the data in unshared columns.
Then you could delete any columns you don't need by selecting the columns you do need, and Delete Columns Other.
Probably easier and quicker. No duplication required.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi,
Use the Append feature of the Query Editor.
Hi @Anonymous ,
So what would the logic be? If 2 Ys then Y, and if two Ns then N? What about the other two cases Y/N, N/Y?
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |