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.
Hi all,
I've got a table that shows
Trainer name, trainee names, expected progress
I'm trying to create a new measure to show the average expected progress for all trainees with each trainer, but am struggling on the syntax. Any help would be appreciated.
Dave J
Solved! Go to Solution.
@Anonymous
Based on your comment, I came up with the following:
Put these on my Google Drive; haven't used this in a while so let me know if links don't work.
@Anonymous
Based on your comment, I came up with the following:
Put these on my Google Drive; haven't used this in a while so let me know if links don't work.
excellent, thanks. I had an error in my syntax, so got nonsensical outcomes. Yours worked perfectly.
cheers
Dave J
Help us out. Post some data and your desired outcome please.
An example of the data below. I'd like to create a measure to say eg
Trainer Expected Progress Actual Progress
A 57.1 62.8
B 65 59.8
where the numbers are the average of all trainees with the trainer (ie total of all actual progress/number of trainees).
Unique Number | Trainee | Title | Actual Progress | Expected Progress | Trainer |
8148685788 | Alan | LGV Driver Standard | 99.3 | 91.2 | Paul Rowden |
6579783779 | Barbara | LGV Driver Standard | 50 | 90.4 | Richard Hicks-Williams |
5252972663 | Charles | Supply Chain Warehouse Operative Standard | 9.1 | 34.3 | Paul Karalius |
7384299356 | David | Supply Chain Warehouse Operative Standard | 2 | 34.3 | Paul Karalius |
3918674052 | Edward | LGV Driver Standard | 29.7 | 50.6 | Stuart Hulme |
3315247578 | Frances | LGV Driver Standard | 29 | 59.4 | Neil Ridgway |
5389836617 | Gail | Supply Chain Operator Standard | 100 | 100 | Chris Moore |
4237732303 | Helen | LGV Driver Standard | 98.8 | 100 | Chris Takle |
3210139201 | Ian | Team Leader Supervisor Standard | 79.7 | 100 | Nichola Dempster |
6924554228 | John | LGV Driver Standard | 52.5 | 93.1 | Phil Greenhalgh |
5754240448 | Keeley | LGV Driver Standard | 49.3 | 99.9 | Ross Wann |
8632404856 | Mick | Team Leader Supervisor Standard | 64.8 | 65.6 | Paula Woolmore |
4385683912 | Noel | LGV Driver Standard | 99.1 | 100 | Darrel Thompson |
9815019936 | Olive | Operations Departmental Manager Standard | 2 | 57.6 | Dave Laing |
1347667678 | Penelope | Team Leader Supervisor Standard | 16.2 | 32.7 | Gail Cooper |
7171066524 | Queenie | Team Leader Supervisor Standard | 36.6 | 56.3 | Paula Woolmore |
3635306788 | Richard | LGV Driver Standard | 21.7 | 71.7 | Phil Greenhalgh |
3053710241 | Stephen | Pearson BTEC Level 3 Diploma in Management (QCF) | 100 | 100 | Nichola Dempster |
6834524281 | Thomas | Team Leader Supervisor Standard | 81.9 | 100 | Gail Cooper |
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |