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 have come across this error and seen it discussed here and would like to see if this makes sence ?
What I have noticed is that if a column that you are pivoting on has the same values as another column, it creates the error.
If I pivot on this column it throws the error because the Lesson column has English as a value. | I use this column as the non aggrigated values. | |
Lesson | Assessment | Points |
English | English | 4 |
English | English Lit | 3 |
English | English | 6 |
Many thanks
Solved! Go to Solution.
If you choose "Don't Aggregate" there are two values for the 'English' assessment. 2 into 1 does not go.
So you either use an aggregate or introduce another column e.g. an Index, to prevent aggregation
If you choose "Don't Aggregate" there are two values for the 'English' assessment. 2 into 1 does not go.
So you either use an aggregate or introduce another column e.g. an Index, to prevent aggregation
Thanks for the response.
Ah think I have got it, the pivot acts like a group query were it needs to group on the other columns and aggrigates the value to stop it appearing on seprate rows.
I've added a key into the list and used Max, when I refresh the error has stopped.
Many thanks @HotChilli
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.