Get Duration from Logged In and Logged Out data per User

NCW — Tue, 13 Dec 2022 14:29:03 GMT

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.

Re: Get Duration from Logged In and Logged Out data per User

amitchandak — Wed, 14 Dec 2022 03:23:49 GMT

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())

Re: Get Duration from Logged In and Logged Out data per User

NCW — Wed, 14 Dec 2022 14:42:20 GMT

This works great. Thanks!

topic Get Duration from Logged In and Logged Out data per User in DAX Commands and Tips

Get Duration from Logged In and Logged Out data per User

Re: Get Duration from Logged In and Logged Out data per User

Re: Get Duration from Logged In and Logged Out data per User