Gentlemen, in my table I have a column CC (Number of Contracts), and another column “DATE” with the dates of each contract, but I want to make a comparison (Something like a PROCV in Excel), where I check in my column CC if have the same contract numbers as the previous days or no. This way I can know exactly if there were new hires or if there were any terminated contracts. That is, what I need is a DAX formula or some mechanism that can be used to carry out this verification, such as an “IF”, IF in my CC column there is a contract for more than the day before, insert it in the column “NEW CONTRACT” , otherwise “CLOSED”.
Image below of my table:
