Calculated Column - time between events in different rows

Hi jpurcell

I think this calculated table might be close

New Table = 


VAR SelfJoin =  
    FILTER( 
        CROSSJOIN( 
                    'Events', 
                    SELECTCOLUMNS( 
                        FILTER('Events', [EventType] in {"Save","Open"}), 
                        "xUserID",[UserID], 
                        "xDateTime",[DateTime] 
                    ) 
                ), 

                [xDateTime] < [DateTime] && 
                [UserID] = [xUserID] 
               
                ) 

VAR LastPurchases =  
    GROUPBY( 
            SelfJoin, 
            'Events'[UserID], 
            Events[DateTime], 
            "Last DateTime",MAXX( 
                                CURRENTGROUP(), 
                                [xDateTime] 
                                ) 
                        
            ) 

RETURN 
    
     ADDCOLUMNS( 
         NATURALLEFTOUTERJOIN('Events',  LastPurchases), 
         "Days since last purchase" ,  IF('Events'[EventType]="Save" , DATEDIFF([Last DateTime],[DateTime],MINUTE),BLANK())
         )

Good afternoon All,

I am quite new to Power BI and DAX function. I need some help in order to resolve bit of tricky calculation. We have Nurse Call System in place where it collects the data from various Health Care Unit (Rooms). The trigger point and Trigger location panel are dotted around the building including key locations such as rooms, lounges, doors, toilets and assisted bathrooms. Normally, there is two events. Call (Start of Event) or Assistance (Start of Event) to trigger notification to all health care assistant and nurses that Patient in care require assistance. Depending on situation and location, health care assistant or nurses present in building either reset alarm trigger or press Present or Accepted (For allocation and go to physically in room before Resetting the call.). So, in a way, it is multiple start point and multiple end points. In this way, the Start of the event is always Call but end of event could be Reset, Accepted, Present.

Below is the sample of data