Solved: Having two table side by side

Kimia79 · ‎10-18-2021

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

Anonymous · ‎10-19-2021

@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').

View solution in original post

v-shex-msft · ‎10-21-2021

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Anonymous · ‎10-19-2021

@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.

Kimia79 · ‎10-19-2021

Thanks for your reply. How can I see the information in one table like the third picture I posted?

Anonymous · ‎10-19-2021

@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').