Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am using PowerBI to query data from a SharePoint List with 50+ columns/fields. The list is used to evaluate team members in projects. The fields consist of some attributes to identify the evaluation (ID Evaluation, Evaluator, Evaluee, Project, Role, Date) and 52 critera, each of which gets rated with a value from 1 to 6.
Each record in the list represents one evaluation of a person. This is displayed in query editor as a flat list. What I need to do is to transform this flat list into an actual data model, allowing me to run reports on it.
Please refer to the pbix at this link (http://sascha-kasper.com/sample.pbix) for details including sample data. The relationship diagram below should give you an idea.
I fail to find a way to get there and would appreciate any help you can provide. Thank you.
Solved! Go to Solution.
Turns out, there is an easy built-in solution. All I had to do was to
And voila, I have a table exactly as I need it.
Thought I would share this with you, hoping it might be useful for others, too.
Turns out, there is an easy built-in solution. All I had to do was to
And voila, I have a table exactly as I need it.
Thought I would share this with you, hoping it might be useful for others, too.
HI @skasper,
For your requirement, I don't think it is simple to achieve. These data may from different tables or need to lookup multiple table to summary records.
In my opinion, you can load tables which contains needed column, summary them with related column, then remove not related column and records.(you will get related entity table)
After these steps, you can use dax functions to create tables based on above entries.
Reference link:
Notice: if your data contains any privacy data, please do mask sensitive data before sharing.
Regards,
Xiaoxin Sheng
Yes, I also think it's not very simple. That's probably why I did not manage to do it on my own, yet. I will try your suggestion though I am not entirely clear how to do it. Thank you for your effort.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |