Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
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.
Solved! Go to Solution.
Does changing your grouping settings as below get you the result you are looking for?
Proud to be a Super User! | |
Thank you very much. It helped.
Does changing your grouping settings as below get you the result you are looking for?
Proud to be a Super User! | |
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 4 |