Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
I have a date column called FileDate, and I'm trying to get the latest date in that column.
I've tries using MAX or LASTDATE in the following ways:
maxFileDate = LASTDATE(('myTable'[FileDate].[Date])
maxFileDate = MAX('myTable'[FileDate].[Date])
maxFileDate = CALCULATE(MAX('myTable'[FileDate].[Date]), All())
All return 12/31/2021 although the last date in that column is Nov 9th
What am I missing here?
Thanks for the help!
Solved! Go to Solution.
@Yaa_D Lose the .[Date] part of your formula and I would use MAX so:
maxFileDate = MAX('myTable'[FileDate])
Hi @Yaa_D
What is your column format, is it Date?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Yup, it's Date
@Yaa_D Lose the .[Date] part of your formula and I would use MAX so:
maxFileDate = MAX('myTable'[FileDate])
Hello @Greg_Deckler , thank you for this tip . I also used it at a similar issue I had and it worked just fine . May I ask what is the implication of using the .[Date] at the end? Thank you, George Giannakis
Perfect. Thank you!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
22 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
32 | |
23 | |
22 | |
22 |