Table creation

[Pavani]

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 .

[Rupak_bi]

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??

[Pavani]

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

[Rupak_bi]

hi @Pavani ,

Please share your sample raw data. Based on the structure on the raw dataset, the desired output can be developped in powerBI