Forum Discussion

dantheram's avatar
dantheram
Icon for Helper II rankHelper II
3 years ago

Consecutive days since target missed

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 num...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago
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's avatar
    dantheram
    Icon for Helper II rankHelper II
    3 years ago

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