Hi all,
I've created a survey in Microsoft Forms which I have connected to Power BI. I've previously analyzed the data in Excel, but to make it more dynamic I'd like to create a report in Power BI instead.
The survey consist of:
- 50 questions (likert scale).
- 7 Dimensions (e.g. each dimension contain a set of questions)
| disagree | Disagree | Agree | agree |
Score for positive items | 1 | 2 | 3 | 4 |
Score for reversed items | 4 | 3 | 2 | 1 |
Some of the questions in the survey are negatively formulated. Meaning, that they use a reversed version of the likert scale.
| Positively formulated items | Reversed formulated items |
Dimension 1- management safety priority and ability (9 items): | A1, A2, A4, A6, A7 | A3, A5, A8, A9 |
Dimension 2 – management safety empowerment (7 items): | A10, A11, A12, A14, A16 | A13, A15 |
Dimension 3 – management safety justice (6 items): | A17, A19, A20, A22 | A18, A21 |
Dimension 4 – workers’ safety commitment (6 items): | A23, A24, A27 | A25, A26, A28 |
Dimension 5 - workers’ safety priority and risk non-acceptance (7 items): | A33 | A29, A30, A31, A32, A34, A35 |
Dimension 6 – Peer safety communication learning, and trust in safety ability (8 items): | A36, A37, A38, A39, A40, A42, A43 | A41 |
Dimension 7 – workers’ trust in efficacy of safety systems (7 items): | A44, A46, A48, A50 | A45, A47, A49 |
The mean score for each respondent is calculated with the following formula:
(A1+A2+(4-A3)+A4+(4-A5)+A6+A7+(4-A8)+(4-A9)) / Number of answered items
The question is if it's possible to replicate this in Power BI? It would make the management of it quite easier as I could set a dynamic refresh of the report.
