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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
sea
Frequent Visitor

max date value

‎08-23-2017 11:56 PM

Hello,

 

+--------------+-------------+
| CUSTOMER     |    DATE     |
+--------------+-------------+
| CUSTOMER 1   |   2.3.2016  |
| CUSTOMER 1   |   3.4.2015  |
| CUSTOMER 1   |   6.6.2017  |
| CUSTOMER 2   |   9.2.2015  |
| CUSTOMER 2   |   7.8.2017  |
| ............ |  ........   |
+--------------+-------------+

How can only show maximum customer dates in this form:

 

+--------------+-------------+
| CUSTOMER     |    DATE     |
+--------------+-------------+
| CUSTOMER 1   |   6.6.2017  |
| CUSTOMER 2   |   7.8.2017  |
| ............ |  ........   |
+--------------+-------------+

Thank you!

Labels:
Message 1 of 2
779 Views
0
1 ACCEPTED SOLUTION
mechanix85
Helper I
Helper I

‎08-24-2017 12:17 AM

MAXDATE:=MAX([DATE])

View solution in original post

Message 2 of 2
992 Views
1 REPLY 1
mechanix85
Helper I
Helper I

‎08-24-2017 12:17 AM

MAXDATE:=MAX([DATE])

Message 2 of 2
993 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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

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

View All