Forum Discussion
Solved
Average of answer by question with multiple value types
Hi, I am analysing survey results and would like to average the answers for a subset of the questions based on their question type. All answers are in a single column. Questiontypes are liker...
Hi Max_Kloosterman,
if you want to analyze just LIKERT questions, then you should import only these ones into Power BI. Do you know how to do that with Power Query?
Once it is imported it's just a matter of defining relationships and using dax AVERAGE function
LivioLanzo
Solution Sage
Solution Sage
Hi LivioLanzo, thanks for your help!
I've put an example comparable to the real data in an excel file on dropbox. Hope that helps!
https://www.dropbox.com/s/ahqosw5ew6kvpid/Example_Data.xlsx?dl=0
Kind regards,
Max