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.

     

Kareus's avatar
Kareus
Helper I
2 years ago

Sorry, stupid question.  How do I share it?

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Google Drive/One Drive.

  • Kareus's avatar
    Kareus
    Helper I
    2 years ago

    Google Drive It Is

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    This measure works

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

    Hope this helps.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    I do nto understand your expected result.  Show that very clearly.

  • Kareus's avatar
    Kareus
    Helper I
    2 years ago

    I'm trying to figure out the periods of time (weeks) to the green box of each running total.

     

    For the Wide RT column.  Your formula is returning 3.  It should be 1 as the frist row is negative.

    I listed the correct answer in green below the "Lead Time - Weeks" table.

     

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    I can try but before that you will need to create a Calendar Table in the file with a week column in there.  Create a relationship (Many to One and Single) from the Good Build Date column to the Date column of the Calendar Table.  Share the download link of the revised PBI file.