Forum Discussion
topazz11
Helper III
Helper IIIDAX Count consecutive
Hi, How do I write DAX to calculate these? I'd like to achieve the Total column number. Thank you,
Hi,
PBI file attached.
Hope this helps.
GeraldGEmerick
Memorable Member
Memorable Membertopazz11 I found a number of references to "Cthulhu" or "Streaks" by Greg Deckler. From what I see the technique should allow you to achieve your desired result. I have not personally tested the DAX code however.
How to find and report on streaks in data | Greg Deckler posted on the topic | LinkedIn