Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
saylee
Frequent Visitor

Max date group by users

‎08-30-2022 10:53 AM

I have a column as firmname, username, user id, login date in different tables. I want to find out last login date for all usernames for their firms. 

Labels:
Message 1 of 2
240 Views
0
1 ACCEPTED SOLUTION
Syk
Super User
Super User

‎08-30-2022 11:02 AM

Add each field to a table visual (this should give you all your data). Then for your login date, click the arrow next to the field and select "Latest". This will be the last login date and will cut down on your # of records to be the max for each user.

Syk_0-1661882514473.png

 



View solution in original post

Message 2 of 2
234 Views
1 REPLY 1
Syk
Super User
Super User

‎08-30-2022 11:02 AM

Add each field to a table visual (this should give you all your data). Then for your login date, click the arrow next to the field and select "Latest". This will be the last login date and will cut down on your # of records to be the max for each user.

Syk_0-1661882514473.png

 



Message 2 of 2
235 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All