Forum Discussion
Solved
calculating average and highest value
I have the follwoing issue and would be happy about some advice. I am building up a skill matrix for people and would like to have a nice representation of what is the average skill per country p...
Hi hummes,
1. In the Query Editor, select skill1 to skill 3 with "CTRL".
2. Unpivot only the select columns.
3. In the Data view, add a calculated column.
SkillScore = len([Value])
4. Add two measure.
SkillAverage = REPT ( "+", ROUNDUP ( AVERAGE ( Table1[SkillScore] ), 0 ) )
Highest = MAX ( 'Table1'[Value] )
You can try it here: https://1drv.ms/u/s!ArTqPk2pu-BkgUGcuY9MxpAkYsgK.
Best Regards!
Dale
Hi hummes,
1. In the Query Editor, select skill1 to skill 3 with "CTRL".
2. Unpivot only the select columns.
3. In the Data view, add a calculated column.
SkillScore = len([Value])
4. Add two measure.
SkillAverage = REPT ( "+", ROUNDUP ( AVERAGE ( Table1[SkillScore] ), 0 ) )
Highest = MAX ( 'Table1'[Value] )
You can try it here: https://1drv.ms/u/s!ArTqPk2pu-BkgUGcuY9MxpAkYsgK.
Best Regards!
Dale
That's very helpfull. Thx.
Slowly getting into this :-)
