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:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     I don't know what the problem is. Could you please provide your pbix file without privacy information and desired output for me to test?

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.