How to get MAX values dates (Calculation views)

[probledo]

I have the following situation:

I currently have a Graphical Calculation View (Image 1) that contains information on Contracts, Contract Status, Change Date of Contract Status (Calday), the problem I have is that I am trying to use Function Max () to determine the "Last date status of a Contract", but the result is not as expected.

Any ideas?

Thank so much for your help!!

Regards!!

[SergioG_TX · Accepted solution]

you need to make your date column as an aggregated column then its function should be max.

keep your dimensions as normal (contract, etc), and your measures as aggregated columns (CALDAY)

[probledo · Accepted solution]

Thank you very much Sergio, you were very helpful !!

[SergioG_TX · Accepted solution]

glad to help!