Forum Discussion
Find last date in a data set with duplicate values
Im trying to get the last day I have a record of extracted from a data set. I have delivery dates that are duplicated, so the LASTDAY formula doesn't work and when I try to use the DISTINCT function ...
Why dont you try MAX ( Table1[Delivery Date]) ?
If this is not you expect, please share how do you want to display the result.
Thanks
Raj
When I try this solution it gives me a date that is not actually in the dataset. Last day in the set is January 18th and it gives me December 31st
Can you provide the data in text format , so that i can copy/ paste and try? Also, out of 3 columns, which column latest date you are trying to fetch?
- Actual Delivery 08/14/2018 07:00 08/28/2018 06:00 09/11/2018 14:00 05/08/2018 09:43 05/22/2018 14:00 01/04/2018 14:38 01/11/2018 09:02 01/25/2018 10:00 01/05/2018 08:00 01/29/2018 08:00 06/04/2018 08:00 07/06/2018 12:00 02/23/2018 09:00 01/04/2018 06:00 01/04/2018 09:00 01/04/2018 10:00 01/04/2018 10:00 01/04/2018 10:00 01/04/2018 10:00 01/04/2018 12:00 01/04/2018 12:00 01/05/2018 08:00 01/05/2018 08:00 01/05/2018 09:00 01/05/2018 09:00 01/06/2018 09:00 01/07/2018 09:00 01/07/2018 10:00 01/07/2018 10:00 01/07/2018 12:00 01/10/2018 08:00 01/12/2018 08:00 01/14/2018 06:00 01/30/2018 13:00 08/24/2018 11:15 09/21/2018 09:47
v-jiascu-msftMicrosoft Employee
Hi Anonymous,
How did you do it? It's good and simple. Please refer to the snapshot below.
Best Regards,