Forum Discussion
Solved
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 b...
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').
VahidDM
Super User
Super UserHi 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!!
It becomes like this.
