Error Combining Data Of Two Tables

[Yrstruly2021]

I am trying to replicate these two "pivot" tables here: https://drive.google.com/file/d/1QwfV0DWBc_5B68K45g-fT6Z1DjiXsLHY/view?usp=sharing so that i can do calculations between the two.

Currently my data model does not allow to filter between these two tables. It gives an error when i select columns from both sets. What am i doing wrong?

PBIX:

  https://drive.google.com/file/d/186vsjbqclSXB4m5LGwdp3agMQ6-63LDs/view?usp=sharing 

[vanessafvg]

use the matrix object rather than the table and place the months on the columns

[vanessafvg · Accepted solution]

hi yours truly from south africa by any chance, i remember all these products 🙂

the problem was your calculated fields cat and one that i removed was creating a circular dependency.  I remove and recreated them and set the relationship to active so you can link them  see attached

[Yrstruly2021]

Thank you. How do i get the months to display  on top as in these: https://drive.google.com/file/d/1QwfV0DWBc_5B68K45g-fT6Z1DjiXsLHY/view?usp=sharing ?