Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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.

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 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!!