Forum Discussion
How to create summary table
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.
neoneo ,
In DAx -
new table = summarize(Table, table[Name], "Average Score" ,Average(Table[Score]))
in power query, you have a group by data
4 Replies
neoneo ,
In DAx -
new table = summarize(Table, table[Name], "Average Score" ,Average(Table[Score]))
in power query, you have a group by data
Thanks for responding.You’re so helpful
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.
