I have a table of data that shows activity in relation to users web activity and I need to establish a time spent on each page for each user.

My data has
  • User name
  • Time landed on the page
  • Any Links clicked on the page

As I have the time the user landed on the page via the link clicked I need to use a MAX function with FILTER to filter for the same Username, the same date and then the maximum time stamp prior to that rows time stamp.

At the moment I am using
Code:
=calculate(max(logs20191002[Time]),filter((logs20191002),logs20191002[webpage_user]=logs20191002[webpage_user]),filter((logs20191002),logs20191002[Date]=logs20191002[Date]),filter((logs20191002),logs20191002[Time]
but this return an empty result.


TIA