Forum Discussion

sagivh's avatar
sagivh
Microsoft Employee
6 years ago
Solved

Aggregate text events with time difference

Hello, I am trying to aggregate events and cannot find the right method to do so.   I have a data similar to this, its basiclaly a list of events with either error or succcess, a timestamp and a un...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi sagivh 

    try new table

    Table = ADDCOLUMNS(summarize('Query';'Query'[User];"Lastevent";LASTNONBLANK('Query'[Event];1);"LastDate";LASTNONBLANK('Query'[Date];1));"diff";if([Lastevent]="success";DATEDIFF(FIRSTNONBLANK('Query'[Date];1);[LastDate];DAY);0))

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

parry2k's avatar
parry2k
Super User
6 years ago

sagivh is there always going to be one success for each user? or there can be multiple failures and successes for each user? Measure is going to be based on that.