Get Duration from Logged In and Logged Out data per User

[NCW]

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.

[amitchandak · Accepted solution]

@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]

This works great. Thanks!