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...
Hi there - I'm stuck on this exact scenario in Power BI - I want to convert my survey answers "1-Not Satisfied, 2- Neutral, 3-Satisfied" etc. to numbers so I can get the weighted average. The tip included states to create a power query in Excel - but how can I do this in Power BI? I have loaded a table to map the answers to numbers, but how can you map that for each question (25 total)?