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?