Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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?