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

Not working as showing below: