I have a large report with all Sports Science data for athletes. One table I am using has all relevant data for a particular piece of technology, in which the columns are sorted Date, Athlete, (Metric 1), (Metric 2).....(Metric 20).
I want to create a baseline for 4 specific metrics from a specific date (Sept. 1, 2022) and each day that is populated thereafter to be calculated as a % deviation from baseline. My data goes back to september 2021, but I need to use this year's September date as the starting point for this season. The data typically looks as follows:
Athlete 1 | 09/01/2022 | 0.6
Athlete 2 | 09/01/2022 | 0.37
Athlete 3 | 09/01/2022 | 0.68
Athlete 4 | 09/01/2022 | 0.43
Athlete 1 | 09/02/2022 | 0.79
Athlete 2 | 09/02/2022 | 0.56
Athlete 3 | 09/02/2022 | 0.6
Athlete 4 | 09/02/2022 | 0.6
I have tried using various DAX formulae to create a measure for this, but cannot figure anything out. Any assistance would be greatly appreciated!
Note: I cannot upload the Excel file for .pbix for this as the data I am using is sensitive.