Consecutive days since target missed

[dantheram]

hi all

as the title says - how do i count the consecutive days since a target value was last exceeded?

i have a count of days under the target and days over but nothing which gives me the number of days since we last failed to meet target.

Guessing i need an equation which gives me the most recent date we beat target and another which looks back from today and counts the days between 

thanks 

Dan

[reidnmorrison]

Can you share a screen shot of the data table (removing any sensitive information) 

[reidnmorrison]

Days since = 
    DATEDIFF(MAX('Dates'[Date]), Today(), DAY)

A measure like this woukld work if you have the date target was last met (can replace 'Dates'[Date] with that data.

[dantheram]

i dont know how to compute the last met date, something like - max - date where delay value < target value?