Streaks with DAX

[k-real]

I am trying to calculate streaks, namely:
- Current Streak, e.g. +3 / -2; or W3 / L2
- Last Winning Streak
- Last Losing Streak
- Longest Winning Streak
- Longest Losing Streak

What I have is a GameSequenceID field that provides an order of games, allowing for multiple games to be played on the same day (essentially, a concatenation of a Date field and a GameNum field). Having linked tables (Players to Teams and Teams to Games), I was able to obtain a result in the WinValidation column with the following formula:
=IF(RELATED(factGameTeams[Result]="Win",1,0)
Same for "Loss" column with "Loss" inserted the formula above.
Now, where I am stuck is the Win Streak column. It feels like it needs an EARLIER function in there, but I just can't wrap my brain around it! Any suggestions?
https://drive.google.com/open?id=0ByH-xaEGJ3BERmg4cW5sNTZNMnc

 

[Matt Allington]

I haven't looked at your workbook, and am not sure of your skill level. But it occurs to me that this problem is similar to one I read about at PowerPivotPro.com.

Read ad it here => Peak Detection: A Surprising Usage of PowerPivot - PowerPivotPro PowerPivotPro

you may be able to work it out after reading this.

 

[k-real]

I haven't looked at your workbook, and am not sure of your skill level. But it occurs to me that this problem is similar to one I read about at PowerPivotPro.com.

Read ad it here => Peak Detection: A Surprising Usage of PowerPivot - PowerPivotPro PowerPivotPro

you may be able to work it out after reading this.

Thanks, Matt! I'll take a look!