Forum Discussion
% change with random dates
I have some workout data that includes a number of fitness tests and I want to be able to calculate progress in these tests. The tests don't take place at regular intervals and there could be any num...
Thank you - I tried the above but still got the same issue. Managed to fix it in the end by making the filter for the previousFTP calculation the same as the others (adding the bit in red):
VAR previousFTP =
CALCULATE (
SUM ( workouts[Avg. Watts] ),
FILTER (
ALL ( workouts ), SEARCH ( "FTP Test Ride", workouts[Title],, BLANK () ) > 0 &&
workouts[Date] = previousDatewithFTP
)
)Thank you for the advice!
What's the reason for using SEARCH ? Do you have scenarios where you want to compare activities where the title is not exactly the same? Please provide more context.
The wider dataset has many other activities with different titles, but it's only the ones with "FTP Test ride" in the title that I want to compare.