Get distinct Course ID for each user

[Arundathi]

Hi Team

I have table like below  which has multiple columns for each user for each question in the feedback form but the submitted feedback and total feedback for that particular user is same for each question is been asked. I want only one row for each user to calculate submitted feedback*100/total feedback like for first three rows it should be like 5*100/20 = 25. I would like to create a graph with the value is generating

Course ID	Country	User	startdate	submitted feedback	total feedback	Material content	Response ID	question type id	question type name
12345	USA	ABC	01-01-2024	5	20	Agree	101	1	matrix
12345	USA	ABC	01-01-2024	5	20	Yes	690	5	Yes/NO
12345	USA	ABC	01-01-2024	5	20	Great	989	7	free text
23456	UK	XYZ	13-01-2024	8	15	Yes	830	2	Yes/No
23456	UK	XYZ	13-01-2024	8	15		120	5	Freetext
23456	UK	XYZ	13-01-2024	8	15	Great	678	7	Matrix
56788	USA	HK	02-02-2024	5	10	Yes	160	5	Yes/NO
56788	USA	HK	02-02-2024	5	10	Great	128	7	Matrix
78901	UK	AK	09-02-2024	8	30	Yes	678	1	Yes/NO

[v-yohua-msft · Accepted solution]

Hi, @Arundathi 

You can then use group by in PowerQuery to achieve the effect you want. Select the desired columns

 And click Group By

Close and apply, then create a new column:

Feedback Percentage = [submitted feedback]*100/[total feedback]

Here is my preview:

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.