Forum Discussion
Anonymous
7 years agoNot applicable
How much time did an user logged in?
Hello guys, Supposed I have the following data of users, each time they logged in and logged out: User LoggingType Date 1 In 2018-10-05 13:18:26.900 1 ...
- 7 years ago
Hi Anonymous ,
Based on my test, you could refer to below steps:
Add index for your data in query editor:
Apply it and create below formula:
Column = var a=[Index]-1 return CALCULATE(MAX(Table1[Date]),FILTER('Table1','Table1'[Index]=a))Result:
Now you could use the [Date] column to minus the [Column].
Regards,
Daniel He
GilbertQ
Super User
7 years agoHi there
What you would need to do, is to create an Index column and then you can create a calculated column which will then put in the data on the corresponding row
This answer explains how to achieve this: https://community.powerbi.com/t5/Desktop/How-to-get-previous-row-value-for-text-column/td-p/312560
What you would need to do, is to create an Index column and then you can create a calculated column which will then put in the data on the corresponding row
This answer explains how to achieve this: https://community.powerbi.com/t5/Desktop/How-to-get-previous-row-value-for-text-column/td-p/312560