Number of days since an footballer went above 90% of their Max Speed

[JSG86]

Hi all, I work with footballers and I want to try and work out the number of days that pass in between the days that they go above 90% of their Max Velocity in training or games. 

This will need to change with the different athlete selected in the slicer and the latest date selected in the slicer too. There may also be days where there is no data (i.e the player was off/away/injured that day)

I have a table named 'GPS Data', and all of the different athletes under [Player Name] and each day under [Session Date]. The Max Velocity efforts are in a column called [Max Vel %] and are inputted as whole numbers. I've attached a little graphic of what I imagine I want it to look like - any help will be much appreicated! TY! 

(Is this even possible?!)

 

[Ahmedx · Accepted solution]

download two files and try, I made you a solution in both DAX and power query

In power query

https://1drv.ms/u/s!AiUZ0Ws7G26RizH8TyS840I3sXVp?e=otqcmg

in DAX

https://1drv.ms/u/s!AiUZ0Ws7G26RizDaaeLY7Kz1O6X2?e=vZCl7N

[JSG86]

That looks like the one! Superstar, thank you!! 

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...