Forum Discussion

Sri_phani's avatar
Sri_phani
Helper III
1 year ago
Solved

Get First Datetime and Last datetime

Hi,

 

I am having a challenge with PowerQuery. I have Activity-wise details, I have to find the Login & Logout from those activities. The first time registered in login and the last time registered is logout within that date. 

 

I tried with an approach of first grouping the data with Employee name and Date. But that is where I am stuck.

 

Example: Below is the grouped data and in the same screenshot raw data is there in table.  From this screenshot employee login will be 10/4/2024 3 AM and logout will be 10/4/2024 5 AM.

 

Sample data -  https://docs.google.com/spreadsheets/d/1gKxpcn6-lXejQt_pIew7irDKvf6yMbdH92YbsgT27zc/edit?usp=sharing

 

 

Thanks in advance. 

 

 

  • Does changing your grouping settings as below get you the result you are looking for?

     

2 Replies

  • Does changing your grouping settings as below get you the result you are looking for?