Table creation
Hi All I need a help to create table like below examples , could you please help. Not a able to attach excel file . No of audit each 1 marks is 17 marks., mean Manindar March month did 6 audi...
Forum Discussion
Hi Rupak_bi ,
Actually that dashboard in excel now need to created power bi , please help to create
1. count No of audits.
2. Marks secured.
3. Total Marks
4. Achived percentage.
5. OverAll Performance (YTD).
Incident ManagerIncident ManagerGrand Total
| March'24 | April'24 | May'24 | OverAll Performance (YTD) | ||||||||||||
| No.of Audits | Marks Secured | Total Marks | Achieved (%) | No.of Audits | Marks Secured | Total Marks | Achieved (%) | No.of Audits | Marks Secured | Total Marks | Achieved (%) | Total no of audits | Total Marks Secured | Total Marks | |
| Manindar | 6 | 93 | 102 | 91.18% | 15 | 254 | 255 | 99.61% | 8 | 136 | 136 | 100.00% | 29 | 483 | 493 |
| Lasya | 6 | 76 | 102 | 74.51% | 10 | 166 | 170 | 97.65% | 9 | 153 | 153 | 100.00% | 25 | 395 | 425 |
| Mohan | 5 | 85 | 85 | 100.00% | 3 | 47 | 51 | 92.16% | 5 | 85 | 85 | 100.00% | 13 | 217 | 221 |
| Valli | 3 | 41 | 51 | 80.39% | 12 | 182 | 204 | 89.22% | 8 | 132 | 136 | 97.06% | 23 | 355 | 391 |
| Sanjana | 7 | 100 | 119 | 84.03% | 9 | 147 | 153 | 96.08% | 5 | 83 | 85 | 97.65% | 21 | 330 | 357 |
| Chaithanya | 8 | 114 | 136 | 83.82% | 3 | 48 | 51 | 94.12% | 1 | 17 | 17 | 100.00% | 12 | 179 | 204 |
| 35 | 509 | 665 | 76.54% | 52 | 844 | 889.9047693 | 94.84% | 36 | 606 | 618.6366514 | 97.96% | 123 | 1959 | 2097.926632 |
