I have a table of test scores where each student as a potential 4 scores with different IDs. I need to be able to filter the IDs to find which is the lowest or highest for each student.
Student 1 lowest score Test4
Once I know which test had the lowest score I can compare their score against the passing criteria and determine if they passed or not.
Any help would be much appreciated!!
Go to Solution.
Use MINX to find the lowest score for a student and then you can use FILTER to filter down to that value for the student.
For example, if you have
Then you could do something like:
VAR __student = MAX([Student])
VAR __table = FILTER(Table,[Student]=__student)
VAR __lowest = MINX(__table,[Score])
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.