Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@neoneo ,
In DAx -
new table = summarize(Table, table[Name], "Average Score" ,Average(Table[Score]))
in power query, you have a group by data
@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
Proud to be a Super User!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |