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
Hi LivioLanzo
Thanks for your help and questions so far - hope the clarification helped?
Kind regards,
Max
LivioLanzo
Solution Sage
Solution SageHi 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