Forum Discussion
Solved
Streak count based on two columns
Hi, I have a table with the following schema ID Capacity Load Hour 1 900 1100 0 1 900 1200 1 1 900 1200 2 1 900 300 3 1 900 200 4 1 900 100 22 1 ...
Ended up adapting the approach discussed here
https://community.powerbi.com/t5/Desktop/Build-measure-or-column-to-show-a-streak-by-consecutive-dates-a/m-p/899915
Ended up adapting the approach discussed here
https://community.powerbi.com/t5/Desktop/Build-measure-or-column-to-show-a-streak-by-consecutive-dates-a/m-p/899915