How to create summary table

[neoneo]

help me please

I have this table

Name      Type             Score

A             Normal               4

A             Special                2

B             Normal               3

B             Special                3

C             Normal              3

C             Special               4

How to create new table like this (for make visualization)

Name        Average Score

A                                  3.0            

B                                  3.0

C                                  3.5

Thank you for your guidance. I appreciate your feedback.

[VijayP]

@neoneo  Follow this:

in the Fields you need to select average instead of Sum (Any Visual)

If  you Find this as solution please notify and share your Kudos

Thanks , Vijay Perepa

[amitchandak · Accepted solution]

@neoneo ,

In DAx -

new table = summarize(Table, table[Name], "Average Score" ,Average(Table[Score]))

in power query, you have a group by data

https://support.microsoft.com/en-us/office/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8...

[neoneo]

Thanks for responding.You’re so helpful

[amitchandak]

@neoneo , Thanks 😀.

In case it is able to resolve your issue. Please accept a solution. Or you can let us know the challenge you are facing.