How to achieve this data view from the given report

Power Query
1

raw data - Employee Exams .xlsx (2.9 MB)
PBI with uploaded raw data Employee Exams.pbix (302.4 KB)

Good evening ,

I would like to ask for some help. I am trying to reshape my data in through Power Query steps and achieve a view below but no success so far.

image
image999×144 11.2 KB

Any help is highly appreciated.

Many thanks,

Iwona

2

Hi @Iwona,

Thank you for reaching out to the community.

While we wait for other members to share their insights, I’ve taken the liberty of using “Explain Simply,” one of the tools available within Data Mentor (you can explore it here: https://mentor.enterprisedna.co/explain-simply). It generated the following results:.

image
image1543×962 107 KB

Feel free to checkout more of our Data Mentor features as you work on your report. These tools are designed to help with tasks like the one you’re working on, and they might accelerate your learning curve.

Cheers,

Enterprise DNA Support Team