Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to Solution.
MAXDATE:=MAX([DATE])
User | Count |
---|---|
112 | |
107 | |
102 | |
56 | |
38 |
User | Count |
---|---|
151 | |
136 | |
99 | |
90 | |
64 |