Forum Discussion
Helper VError Combining Data Of Two Tables
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
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
3 Replies
- vanessafvg
Community Champion
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
Yrstruly2021Thank 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 ?
- vanessafvg
use the matrix object rather than the table and place the months on the columns