topic Showing Earliest Date in DAX Commands and Tips

Showing Earliest Date

Anonymous — Mon, 18 Oct 2021 16:56:52 GMT

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!

Re: Showing Earliest Date

VahidDM — Tue, 19 Oct 2021 01:08:22 GMT

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

Re: Showing Earliest Date

Anonymous — Tue, 19 Oct 2021 12:31:48 GMT

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:

Re: Showing Earliest Date

v-yingjl — Fri, 22 Oct 2021 02:23:36 GMT

Hi Anonymous ,

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

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

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.