Forum Discussion

NCW's avatar
NCW
Frequent Visitor
3 years ago
Solved

Get Duration from Logged In and Logged Out data per User

I am looking to find the total time users are logged into our system. The way the data is exported currently does not show how long they were logged in. I don't know the best way to do this within Power BI. 

This is a snippet of what the CSV data looks like. I am able to export a table of Logged In and Logged Out seperately but I thought this would be better.

 

I was thinking the equation to do it would look like:

 

If Action = "RemoteLoggedIn" (some how store UserName)

Then find the next instance of "RemoteLoggedOut" and UserName1 = UserName2

Then Date2 - Date1 = Duration

 

I don't know how to do this within PowerBI or what the best way to implement this. It seems easier in a different language, especially with loops and storing of variables. But I am new to PowerBI and I am struggling to figure this one out.

  • NCW ,

    a new column = if([Action] = "RemoteLoggedIn",

    datediff( [Date], Minx(filter(Table, [user Name] = earlier([User Name]) && [Action] ="RemoteLoggedOut" && [Date] > Earlier([Date]) ) ,[Date]), Minute) , Blank())

2 Replies

  • NCW ,

    a new column = if([Action] = "RemoteLoggedIn",

    datediff( [Date], Minx(filter(Table, [user Name] = earlier([User Name]) && [Action] ="RemoteLoggedOut" && [Date] > Earlier([Date]) ) ,[Date]), Minute) , Blank())

    • NCW's avatar
      NCW
      Frequent Visitor

      This works great. Thanks!