Forum Discussion

Kareus's avatar
Kareus
Helper I
2 years ago
Solved

Running Total Help

How can I determine the first intance the running total is less than or equal to 0?

 

In this case I want the result to be 6.

As its the first week that is non-zero.

 

 

Thank you!

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    This measure works

    Measure = COUNTROWS(FILTER(VALUES('Resource Priority'[RT Good Week]),[10K 2PLD RT]>0))+1

    Hope this helps.

     

16 Replies

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        That is the first instance when the RT is <0.  In your original post, you mentioned that you wanted to know the first instance when the RT is >0.