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.

  • 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.