Finding the averages of different halves of a data set
Hi, I wish to find a "trajectory" score for each individual. I have a dataset that has a score recorded for an individual during a particular time. I would like to find the average score for the first half of the data (the values achieved before the median of the time scores) and then the average score for the second half of the data by time. Then find the difference which will be shown in a card after someone is selected by a slicer. The table is called Track Data.
I have tried:
average of first half = calculate(AVERAGE(value),'Track Data'[Number Time]<=median('Track Data'[Number Time]))
I think I can see why this fails but not sure about the fix.