Forum Discussion
Average of answer by question with multiple value types
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
There is no correct answer. The statements are scored disagree completely (1) to agree completely (5).
Hope that clarifies,
Kind regards,
Max
Solution SageHi Max_Kloosterman,
What about the questions which are not LIKERT? The ones with OPEN Text and YN, should they not be considered?
Hi LivioLanzo,
sorry for my late reply!
The open questions can be ignored, the Y/N questions as well. The likert questions are the basis for a comparison between respondents / groups of respondents.
This is probably where I stranded, I couldn't get a measure calculated on the column containing the likert scores (as well as the other scores) to work.
Kind regards,
Max
Hi LivioLanzo
Thanks for your help and questions so far - hope the clarification helped?
Kind regards,
Max
- LivioLanzo
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