How to evaluate the Max date of a set of a dates according to an ID

[Anonymous]

Hi All,

I am trying to evaluate for each object ID which is the Max Date, since then I need to count those Object ID in a established date period. How should I proceed?

Sample Data with several Object IDs, divided by their Steps, and each step with its own approval date.

Thanks & Regards,

[aj1973 · Accepted solution]

Hi @Anonymous 

MaxDate = 

var _id = SELECTEDVALUE(TABLE[Object ID])

return

CALCULATE( MAX(TABLE[Approval Date]), TABLE[Object ID] = _id)

[parry2k]

@Anonymous you can add a column using the following expression:

Max Date = CALCULATE ( MAX ( Table[ApprovalDate] ), ALLEXCEPT ( Table, Table[ObjectId] ) ) 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡