Forum Discussion
Calculating customer satisfaction scores
Hi This is my first post but i have been using Power BI for a few months now. I'm struggling with getting a percentage score from DAX and need some help. I have two customer satisfaction surveys,...
You should unpivot your data such that you table looks more like
Emp SurveyID QuestID Score
1 1 1 1
1 1 2 2
etc
This structure will make it much easier to get individual scores.
Hope this helps
David
dedelman_clng
Community Champion
Community ChampionYou should unpivot your data such that you table looks more like
Emp SurveyID QuestID Score
1 1 1 1
1 1 2 2
etc
This structure will make it much easier to get individual scores.
Hope this helps
David