Forum Discussion
Unique contract
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 |
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,
1 Reply
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,