Forum Discussion
Transform Data from SharePoint List
Turns out, there is an easy built-in solution. All I had to do was to
- go to the flat table of evaluation results in Query Editor
- select the columns which are the 'metadata' for each result (i.e. ID, Evaluator, Evaluee, Title, Created)
- unpivot all other columns (either right-click in the selected area or choose the option from the menu ribbon)
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.