Forum Discussion
Having two table side by side
Hi,
I have two tables with almost the same data. The first one shows the current Subject pattern, and the second one shows the Online subject.
I need to see these two tables side by side—something like this, but in power bi.
Can Anyone help me?
https://www.dropbox.com/s/a4li07xl31xi5to/online%20subject.pbix?dl=0
Kimia79 Just create pivot table based on result table with 'Name' and 'Teacher' on rows, 'Current/Online' and 'Subject' on columns and 'Values' on values (in last message I missed one column you should get in the end result - 'Values').
9 Replies
Hi Kimia79
You can merge those two tables in the Power Query.
see this link:
https://radacad.com/how-to-change-joining-types-in-power-bi-and-power-query
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Kimia79 You need to create two tables with four fields: "Name", "Teacher", "Subject", "Current/Online".
For that you should unpivot columns with subjects and rename new column as "Subject"; then add new cutom columns "Current/Online" and type in for each table as a value "Current subject pattern" and "Online subject pattern" respectively. After that just append two tables.
Thanks for your reply. How can I see the information in one table like the third picture I posted?
Kimia79 Just create pivot table based on result table with 'Name' and 'Teacher' on rows, 'Current/Online' and 'Subject' on columns and 'Values' on values (in last message I missed one column you should get in the end result - 'Values').
Hi Kimia79,
Did these suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
