Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Running Total Required

Hi All I have data below I need Running Total of VarFlag for Employee, Date, Day , kindly help 
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous So maybe something like:

Running Total Measure = 
  VAR __EmplyID = MAX('Table'[Emply ID])
  VAR __Date = MAX('Table'[Date])
  VAR __Table = FILTER(ALL('Table'), [Emply ID] = __EmplyID && [Date] <= __Date)
RETURN
  SUMX(__Table, [VarFlag])
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Its showing as below 

While I need 1,2,3,4,5 and whenver there is 0 for "D/O " next row should restart from 1,2,3 and so on.

 

Actually I want to display the no of consecutive days an employee has worked. So if employee has value D/O is day off , then next day should start from 1, 2,3 4 and so on.