Unique contract

[Anonymous]

Hi All, I don't know if I put this in the right forum now, but I hope you can help me.

I have a variable "Contract type" were I have all the contracts that a person can sign, four different ones. I only want to extract the latest of the two most recent "pre-contract" or "Rental agreement" for each unique person (CostumerId)

Costumer id	Contract typ	Contract date	What I wont have
1	pre-contract	2020-01-01	No
1	Rental agreement	2020-02-01	Yes
2	pre-contract	2020-03-01	Yes

[philouduv · Accepted solution]

Hello @Anonymous ,

I'm sure there exist more optimize way to do that but a quick calculated column such as the following screen can do the trick.

To do so I copy paste your data source, kept your column What I want have as reference and built a new calculated column called Dax_column

Best regards,