Forum Discussion
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 "...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhmPkQZ6EPjMyKyuS?e=iVbqzL
Thanks for the reply. On the result, this OK, however I have left another condition: - there may be records with cancellation date but that does not have duplicate the order. in this case, it should also be OK. Please your help. Thank you.