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 ...
  • 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.

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.