Forum Discussion
Creating a table from survey responses with number values instead of text responses
Microsoft EmployeeHi sallen,
Could you post all your table structures with some sample data, and your expected result, so that we can better assist on this issue? It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:
Regards
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.
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.
