Forum Discussion
Survey Scoring Table
Hi all, I have a survey from survey monkey that I have loaded into Power Bi. Its a column (the question) with the response below it as the value. In addition to this, I created a tab...
Anonymous , You can replace option in Power Query editor /Data Transformation
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak My forum status won't let me share pbix documents for some reason. But I'll create tables in here if that helps.
| How often are employees equipped? | Are observational routines utilized? | Do these take into consideration safety guidelines? |
| Sometimes | Yes | No |
| Sometimes | 2 |
| Yes | 1 |
| No | 0 |
I want these to turn into this:
| How often are employees equipped? | Are observational routines utilized? | Do these take into consideration safety guidelines? |
| 2 | 1 | 0 |
Does this help?