Forum Discussion
Current Streak Calculation
I am trying to calculate a measure of the streak of data for consents per person. I have tried numerous recommendations from others and the only youtube video I found that is related. However, it only counts the streak of "Yes", so I have been able to do that.
However, I need the streak of Yes AND Nos. I also need to add the filter that Approached must be Yes, as there are other rows where Approached is No.
| Name | Date | Approached | Consent |
| Mike | 1/1/2024 | Yes | Yes |
| John | 1/2/2024 | Yes | No |
| Andrew | 1/3/2024 | Yes | No |
| Andrew | 1/4/2024 | Yes | Yes |
| Mike | 1/5/2024 | Yes | Yes |
| John | 1/6/2024 | Yes | Yes |
| John | 1/7/2024 | Yes | No |
Desired Measure Result
| Name | Streak |
| Mike | 2Yes |
| John | 1No |
| Andrew | 1Yes |
I have spent hours trying to figure this out, as it is more complicated than it seemed.
1 Reply
ARomain57 Don't feel bad, it actually is a bit complicated. See these links:
