Forum Discussion
Creating a table from survey responses with number values instead of text responses
Hey guys, I am working with survey data which put simply has the questions as columns and the respondents as rows. So each column has values in it either like agree/ disagree, satisfied/ dissatis...
I have the same problem, I have many question with answeres that can be Satisfied, Dissatisfied, Very dissatisfied...
I need to count the amount of each category (Satisfaied = 80, Very Satisfied = 10 ..) and also convert them into number from 1 to 5 depending on the answered ( Satisfied =4, Very Satisfied =5...)
You can create add a new table in your model that maps the string values to numbers and then in Power Query merge your table with the created table.