Session Duration

Hi Dimitris_Kats 

Thanks to OwenAuger for his great response to this thread.

Please allow me to add a possible solution below, i hope it helps.

Create the following measures:

OperationTime = MAX('Audit'[Creation time])

PreviousOperationTime = 
VAR CurrentUser = MAX('Audit'[User (UPN)])
VAR CurrentTime = MAX('Audit'[Creation time])
RETURN
CALCULATE(
    MAX('Audit'[Creation time]),
    FILTER(
        'Audit',
        'Audit'[User (UPN)] = CurrentUser &&
        'Audit'[Creation time] < CurrentTime
    )
)

SessionDuration = 
VAR PrevTime = [PreviousOperationTime]
VAR CurrTime = MAX('Audit'[Creation time])
RETURN
IF(
    ISBLANK(PrevTime),
    0,
    DATEDIFF(PrevTime, CurrTime, SECOND)
)

TotalSessionDuration = 
VAR VirtualTable = 
    ADDCOLUMNS(
        SUMMARIZE(
            Audit,
            Audit[User (UPN)],
            Audit[Creation date],
            Audit[Operation]
        ),
        "SessionDurationValue", [SessionDuration]
    )
RETURN
    SUMX(
        VirtualTable,
        [SessionDurationValue]
    )

Create a matirx visual:

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

Thank you so much both for your help.
It was really valuable to me.

The measures that gave me the desired result are the following: