Showing Earliest Date

[Anonymous]

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!

[Anonymous]

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 · Accepted solution]

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.

[VahidDM]

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!!