Forum Discussion
Helper IVExpression.Error: There were too many elements in the enumeration to complete the operation.
e175429 I believe buffering the table would remove the enumeration error. I have tried to replicate your requirement using a mockup data and have achieved the output you are expecting. The PBIX file is attached for your reference.
Input Data:Output:
You can remove the last before step if you want to display nulls instead of "No Response" for the users who haven't answered the questions.
Hope this helps !
Thanks,
Jai
Super UserThis error would happen if you have any cases where the same person took the survey multiple times on the same day.
If the pivot works when you switch Don't Aggegate to take a max or a min instead, then I bet that's the problem. If that's the problem, you'll need to decide how you want to aggregate the records.
e175429It doesn't matter what aggregate function i choose, it does the same thing of triple counting the records.