Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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 ,
a new column = if([Action] = "RemoteLoggedIn",
datediff( [Date], Minx(filter(Table, [user Name] = earlier([User Name]) && [Action] ="RemoteLoggedOut" && [Date] > Earlier([Date]) ) ,[Date]), Minute) , Blank())
This works great. Thanks!