Forum Discussion
relations
Hi, I've two tabels: Employee Consult and Scanvragen MC. In the tabel Employee Consult are colomns with questionscores. The name of the colomn is the code of te question. The questions with the ...
The idea is you first need to transport or pivot the first table in to something like:
| Code | Employee 1 | Employee 2 |
| ECMW001 | 60 | 100 |
| ECMW002 | 60 | 100 |
| ECMW003 | 60 | 80 |
| ECMW004 | 60 | 80 |
| etc.... |
Then once you related the 2 tables with Code columns, you can just drage code, question, employee scores to a table visual in the report.
However, you could provide the sample pbix file if you need a definite solution.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Thanks for Your reply. Where can I find the sample pbix?
Jacques
