Date sequence validation for duplicates

Hello everyone

I appreciate if you can help me with this consultation. I have the following table:

I need to perform the following validations:

- check if there is duplicate data in the "Order" column since it is with this data that I will work.

- once identified, validate that the number of the "Invoice" field whose "Status" field is "FILED" is less than the second record

- After that, validate that the "Cancellation Date" of the line indicating "FILE" of the duplicate pair is later than the "Date of issue" of the same line and that, in turn, it is prior to the date of issuance of the second record (the one with the invoice number greater than the duplicate pair. consider date and time.

- if this sequence is correct, indicate OK in the "Result" field of the line in which the "Status" field indicates "FILE".

- if incorrect, indicate "Error".

- For orders that are not duplicated, leave the "Result" field blank

Finally, create a calculated measure that counts how many "Errors" there are in the column, without counting blank spaces.

The result would be something like this:

I hope you can help me.

Thank you so much!