Forum Discussion

Step927's avatar
Step927
Regular Visitor
1 year ago
Solved

Consecutive days with no increment in Running Total

Dear All,   I want to create a calculated column that returns a string if a Player has an increment in goal scored compared with the previuos day. Please consider that  "goal " is a running total....
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Try this calculated column formula

    Column = calculate(countros(Data),filter(Data,Data[Name]=earlier(Data[Name])&&Data[Day]<=earlier(Data[Day])&&Data[Goal]=earlier(Data[Goal])))

    Hope this helps.

DataStep's avatar
DataStep
New Member
1 year ago

Hi rajen,

thank you it works very well!

In addiction, which will be the best way to return the count of consecutive giornata with "No".
Looking the table I attached, for the day 7 the correct value would be 0.
For the day 15 the correct value would be 3,
For the day 16 the correct value would be 4
Fo the day 17 the count restart from 0.

Do you suggest a measure or a new calculated column?
Many Thanks

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Try this calculated column formula

Column = calculate(countros(Data),filter(Data,Data[Name]=earlier(Data[Name])&&Data[Day]<=earlier(Data[Day])&&Data[Goal]=earlier(Data[Goal])))

Hope this helps.

  • DataStep's avatar
    DataStep
    New Member
    1 year ago

    It works correctly!! Many Thanks

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      1 year ago

      You are welcome.  If my reply helped, please mark it as Answer.