Forum Discussion
Difference in time from one IP to another
Hi RIDWIV ,
Here's my solution.
1.Create a calculated column to get the rankings group by Client ID based on datetime.
Rank = RANKX(FILTER('Table',[Client ID]=EARLIER('Table'[Client ID])),[Login Date & Time],,ASC,Dense)Then you can use DATEDIFF function to get the time intervals.
Seconds = var _pre=CALCULATE(MAX('Table'[Login Date & Time]),FILTER(ALL('Table'),[Client ID]=MAX('Table'[Client ID])&&[Rank]=MAX('Table'[Rank])-1)) var _cur=MAX('Table'[Login Date & Time]) return DATEDIFF(_pre,_cur,MINUTE)When you use the slicer, the time interval from one IP to another in chronological order in the Client ID is displayed.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
please cross check my formula
Rank = RANKX(FILTER('login_list',[clientid]=EARLIER('login_list'[clientid])),[loginDateTime],,ASC,Dense)Seconds = var _pre=CALCULATE(MAX('login_list'[loginDateTime]),FILTER(ALL(login_list),[clientid]=MAX('login_list'[clientid])&&login_list[Rank]=MAX(login_list[Rank])-1))var _cur=MAX(login_list[loginDateTime])return DATEDIFF(_pre,_cur,SECOND)
Hi RIDWIV ,
Here's my solution.
1.Create a calculated column to get the rankings group by Client ID based on datetime.
Rank = RANKX(FILTER('Table',[Client ID]=EARLIER('Table'[Client ID])),[Login Date & Time],,ASC,Dense)
Then you can use DATEDIFF function to get the time intervals.
Seconds = var _pre=CALCULATE(MAX('Table'[Login Date & Time]),FILTER(ALL('Table'),[Client ID]=MAX('Table'[Client ID])&&[Rank]=MAX('Table'[Rank])-1))
var _cur=MAX('Table'[Login Date & Time])
return DATEDIFF(_pre,_cur,MINUTE)
When you use the slicer, the time interval from one IP to another in chronological order in the Client ID is displayed.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
please cross check my formula