Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Multiple codes in one cell - options for analysis

Dear Community,    I am trying to analyze a survey with PowerBI that has a number of Multiple Choice questions, whereas each response option is associated with an ID (1,2,3,...; 1=bus, 2=car etc.)....
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks!

I tried that but the effect is that the number of lines in my table increases, which in turn increases the count for any data analyses (i.e. I have ca. 500 surveys, but due to the multiplication of questionnaire IDs, PowerBI implies that I have much more than these 500 surveys. And this might even skew the analyses I am running, if I am not mistaken. Any solution to this as well?

 

Best wishes

Simon