Forum Discussion
Creating new table with distinct rows from single column with multiple value types
Good day! I am trying to do a few things with a table in order to filter by values in a single column, and also to calculate scores for the whole. I have a table from a form with a unique Acc...
lbendlin
Super User
Super UserWhat I would like to do is create a table where the unique answers are placed into distinct columnsDon't do that. Power BI is not Excel. Your data is already in a good format. Leave the pivoting work to the matrix visual.
Thank you for the tip! I have no experience with that particular visual so I will explore it and see if I can get it to do what I need.
*Edit* Unfortunately I am in the same boat as before, and likely need a new measure or something to calculate score in order to use the matrix effectively as it does the same thing when I filter the page, clicking on an item to drill in and then the scores disappear.