Find last date in a data set with duplicate values

[nicolasgh96]

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 before the LASTDAY function I still get an error message.

[Anonymous]

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

[nicolasgh96]

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

[Anonymous]

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?

[nicolasgh96]

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-msft]

Hi @nicolasgh96,

How did you do it? It's good and simple. Please refer to the snapshot below.

Best Regards,