Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Showing Earliest Date

Hello!

I have a report pulling from our database regarding purchase orders and when they are received. Since a purchase order can contain many items that get received on different days, I'd like to have a way to only pull the latest day. Right now, It's showing each receipt on its' own line. 

Thanks!

 

  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi Anonymous ,

    Try to disable 'Show data with no item' and use LastDate()

    Measure = LASTDATE('Table'[PurchRec.Date])

    Or

    Measure 2 = 
CALCULATE(
    MAX('Table'[PurchRec.Date]),
    ALLEXCEPT('Table','Table'[PurchRec.Date])
)

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

     

    You can summarize your table to show the latest day for each PO, or you can use MAX or LASTDATE to find that. It depends on your data model and the result you are looking for.

     

    Can you share a sample of your data and result?

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Below is a screenshot of what I'm looking at. Each Job has multiple items that have to be received. Instead of showing me all of the dates where the job was received, I just want the last one.

     

     

    When I use the LASTDATE function, it gives me the same result: 

     

    When I use the MAX function, it shows me this, which doesn't make sense because nothing can be recieved in the future: 

     

     

    • v-yingjl's avatar
      v-yingjl
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi Anonymous ,

      Try to disable 'Show data with no item' and use LastDate()

      Measure = LASTDATE('Table'[PurchRec.Date])

      Or

      Measure 2 = 
CALCULATE(
    MAX('Table'[PurchRec.Date]),
    ALLEXCEPT('Table','Table'[PurchRec.Date])
)

       

      Best Regards,
      Community Support Team _ Yingjie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.