Forum Discussion
samirfarid
7 years agoFrequent Visitor
How to sum data from SharePoint onto a report
Hi,
I currently retrieve some data from a SharePoint list which is stored in a DAX table as follows:
| Id | Question 1 | Question 2 | Question 3 | Comments |
| 1 | Yes | Yes | No | Lorem Ipsum |
| 2 | Yes | No | Yes | Lorem Ipsum dolor sit amet |
| 3 | (Blank) | No | No |
On my Dashboard, I'm want to be able to show a Table / Matrix that shows the amount of Yes, No and blank answered questions. Something like this for example:
| Yes | No | Empty | |
| Question 1 | 2 | 0 | 1 |
| Question 2 | 1 | 2 | 0 |
| Question 3 | 1 | 2 | 0 |
I read somewhere that this could be achieved using unpivoting in Power Query, but as my list contains about 15 questions and a lot of records, i was wondering whether unpivoting wasnt too much trouble performance wise, or if there is a simpeler way to achieve this.
Thanks for the help.
1 Reply
- v-chuncz-msftCommunity Support