Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 audit marks got 93, over all marks is 102( 6 Audit marks * 17 Marks =102)
Incident ManagerIncident Manager97.97%92.94%98.19%90.79%92.44%87.75%Grand Total
March'24 | April'24 | May'24 | OverAll Performance (YTD) | |||||||||
No.of Audits | Marks Secured | Achieved (%) | No.of Audits | Marks Secured | Achieved (%) | No.of Audits | Marks Secured | Achieved (%) | Total Incidents | Total Points | Overall (%) | |
Manindar | 6 | 93 | 91.18% | 15 | 254 | 99.61% | 8 | 136 | 100.00% | 29 | 483 | |
Lasya | 6 | 76 | 74.51% | 10 | 166 | 97.65% | 9 | 153 | 100.00% | 25 | 395 | |
Mohan | 5 | 85 | 100.00% | 3 | 47 | 92.16% | 5 | 85 | 100.00% | 13 | 217 | |
Valli | 3 | 41 | 80.39% | 12 | 182 | 89.22% | 8 | 132 | 97.06% | 23 | 355 | |
Sanjana | 7 | 100 | 84.03% | 9 | 147 | 96.08% | 5 | 83 | 97.65% | 21 | 330 | |
Chaithanya | 8 | 114 | 83.82% | 3 | 48 | 94.12% | 1 | 17 | 100.00% | 12 | 179 | |
35 | 509 | 76.54% | 52 | 844 | 85.43% | 36 | 606 | 88.60% | 123 | 1959 | 83.83% | |
Manindar | 102 | 255 | 136 | 493 | ||||||||
Lasya | 102 | 170 | 153 | 425 | ||||||||
Mohan | 85 | 51 | 85 | 221 | ||||||||
Valli | 51 | 204 | 136 | 391 | ||||||||
Sanjana | 119 | 153 | 85 | 357 | ||||||||
Chaithanya | 136 | 51 | 17 | 204 | ||||||||
Grand Total | 665 | 988 | 684 | 2337 |
The table should be like below example, Please any one help .
Hi,
Your ask is not clear to me. you want to create a calculated table manually like this or you already have a dataset and wants to represent that in this way??
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 |
hi @Pavani ,
Please share your sample raw data. Based on the structure on the raw dataset, the desired output can be developped in powerBI
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |