Return Duration

[mikeymay]

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

=calculate(max(logs20191002[Time]),filter((logs20191002),logs20191002[webpage_user]=logs20191002[webpage_user]),filter((logs20191002),logs20191002[Date]=logs20191002[Date]),filter((logs20191002),logs20191002[Time]<logs20191002[Time]))

but this return an empty result.


TIA