relations

[jaspijk]

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 codes are in the second table, Scanvragen MC. I want tot report from te first table the quistionscores with the questionteks form te second table. I don't know how to do that.

[jaspijk]

Still not found a solution. Don't know how to pivot the first table in a correct way.

[Anonymous]

@jaspijk 

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.

[jaspijk]

@Anonymous

Thanks for Your reply. Where can I find the sample pbix?

Jacques

[amitchandak]

@jaspijk ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[jaspijk]

Hi,

Was my econd message clear enough for You?

[jaspijk]

amitchandak,

thansks for your quick reply!

In tehe first tabel You see the colomns ECCO001, ECCO002, ECCO003, ....... The colomn-names are corespondending with a field in he second table 'vraagcode'. I want tot use 'vraagtekst' from the second table as the colomnames of the first to report the results. So instead of reporting ECCO001 with the everagescore of 89, I want to report the corrrespondeding text woth tehe score.

Now I get:

And I want:

'Dat de organisatie een duidelijke visie heeft' (text in the second table)

89