Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I havae the following table
ID | DATE | QUESTION | ANSWER |
123 | 01/01/2023 | name | jorge |
123 | 01/01/2023 | age | 17 |
123 | 01/01/2023 | gender | male |
456 | 01/02/2023 | name | lara |
456 | 01/02/2023 | age | 24 |
456 | 01/02/2023 | gender | female |
I want to transform the rows into columns, like this:
ID | DATE | NAME | AGE | GENDER |
123 | 01/01/2023 | jorge | 17 | male |
456 | 01/02/2023 | lara | 24 | female |
is an example, the table I have has 19 questions and when I use the dynamic columns option and select the option to not summarize the data, the following error appears:
Expression.Error: There were too many elements in the enumeration to complete the operation.
Details:
[List]
Solved! Go to Solution.
=Table.Pivot(YourTable,List.Distinct(YourTable[QUESTION]),"QUESTION","ANSWER",each _{0}?)
=Table.Pivot(YourTable,List.Distinct(YourTable[QUESTION]),"QUESTION","ANSWER",each _{0}?)
Thank you!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.