Forum Discussion
Average Data
Hello, Still farily new to Power BI, and really green with DAX. Normally in Excel I would create a new row that shows the average of the information, but I am not sure how to do it in Power Bi. ...
Hello,
No I have quality metrics on another table, I have post call information on another, and then I have performance data on this one. I have tables made up of associates, and one for managers as well. I know it's not grat to have a flat table, but as I said I still pretty new at this. Any tips I would gladly take, as of language I am pretty much self taught.
| Associate | Period | ACW % | Unattached ACW % | Aux 9% | Aux 9 Minutes | AHT | EMAIL APT | Non-Compliant Lunch | Non-Compliant Break | Total Non-Compliant | Customer XP Average | Utlization |
| Alborollosy, Hanaa | 1 | 38.18% | 5.08% | 0.26% | 24.20 | 1275.22 | 25.43 | 177 | 210 | 387 | 101.59% | |
| Alborollosy, Hanaa | 2 | 34.64% | 2.45% | 0.46% | 51.02 | 1003.22 | 21.34 | 199 | 209 | 408 | 70.76% | 100.32% |
| Alborollosy, Hanaa | 3 | 33.74% | 3.35% | 0.08% | 4.87 | 793.79 | 19.07 | 51 | 98 | 149 | 55.77% | 100.00% |
| Allison, Jack | 1 | 0.20% | 1.18% | 1.03% | 102.33 | 349.28 | 13.54 | 37 | 54 | 91 | 92.80% | 85.05% |
| Allison, Jack | 2 | 0.13% | 1.15% | 0.55% | 65.85 | 386.12 | 13.26 | 21 | 49 | 70 | 88.38% | 89.19% |
| Allison, Jack | 3 | 0.04% | 0.94% | 1.08% | 104.03 | 387.31 | 13.16 | 2 | 21 | 23 | 94.19% | 89.72% |
| Allison, Jack | 4 | 0.03% | 2.04% | 1.07% | 103.05 | 400.88 | 14.04 | 31 | 28 | 59 | 94.19% | 85.89% |
| Amey, Dianna | 1 | 7.48% | 3.40% | 2.27% | 217.17 | 525.15 | 12.60 | 284 | 344 | 628 | 97.22% | 0.00% |
| Amey, Dianna | 2 | 8.47% | 0.93% | 0.54% | 67.68 | 510.68 | 9.75 | 236 | 562 | 798 | 57.13% | 0.00% |
| Amey, Dianna | 3 | 13.91% | 3.36% | 0.73% | 56.00 | 580.62 | 9.30 | 76 | 346 | 422 | 50.00% | 0.00% |
| Amey, Dianna | 4 | 7.15% | 3.35% | 0.57% | 45.78 | 565.25 | 14.41 | 110 | 348 | 458 | 93.94% | 0.00% |
Anyone have any advice?