Percent difference for two average scores
Hi Power BI Brain Super-Powered,
I could use your thought partnership on this issue.
I have average scores for six categories. However, I would like to calculate the percent difference between two average scores at a time.
I envision a percent change of Average Score Dashboard BEFORE vs Average Score Dashboard NOW, Average Score Performance BEFORE vs Average Score Performance NOW, and Average Score Change Management BEFORE vs Average Score Change Management NOW.
I figure that I have to use the average score DAX (
in the % change DAX. But I am not sure about the rest of the % Change DAX. This post seems promising but unsure of how I can adapt DAX.
All nudges are greatly appreciated!
| Category | Score |
| Dashboard BEFORE | .XXXX |
| Dashboard NOW | .XXXX |
| Progress Monitoring BEFORE | .YYYY |
| Progress Monitoring NOW | .YYYY |
| Change Management BEFORE | .ZZZZ |
| Change Management NOW | .ZZZZ |
Progress Knowledge Data Table
Progress Knowledge Visual