Hello All. I am creating an exercise tracking app (thanks Covid!). I am trying to figure out how to create a virtual column to contain the latest date/time when my highest output occurred. The data is in a single table and the columns of interest are [Date Of Workout] and [Total Output].
I created a [Max Output] VC that gets me the MAX OUTPUT from the records of interest:
MAX(SELECT(Workouts[Total Output],AND([Fitness Discipline]="Cycling",[Total Output]>0)))
I am now trying to create a VC for [Date of Max Workout], which means I need to find the latest workout record from those where the max output occurred. So… was hoping to SELECT all the records where [Total Output] = [Max Output], and then select only the latest workout record from that subset.
Can anyone suggest the easiest formula to do this?