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 "...
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hello, thanks for the clarification.
I attach the requested detail:
Invoice Order State Issue date Cancellation date Result 235-2023-000478 000173751473 LEGAJADA 01/02/2023 19:23:22 01/02/2023 19:27:02 ok 235-2023-000481 000173751473 Regularized 01/02/2023 22:27:27 235-2023-000026 014494368514 LEGAJADA 03/01/2023 18:29:02 04/01/2023 18:24:54 Error 235-2023-000046 014494368514 Regularized 04/01/2023 18:23:30 235-2023-000176 014494368993 Regularized 12/01/2023 18:47:41 235-2023-000181 014494368993 Regularized 12/01/2023 18:47:41 235-2023-000185 014494369015 LEGAJADA 13/01/2023 00:19:03 13/01/2023 00:22:56 Ok 235-2023-000201 014494369015 Regularized 13/01/2023 19:39:18 235-2023-000186 014494369026 LEGAJADA 13/01/2023 00:19:03 13/01/2023 00:22:57 Ok 235-2023-000202 014494369026 Regularized 13/01/2023 19:39:18 235-2023-000204 014494369030 Regularized 13/01/2023 19:39:18 235-2023-000249 014494369170 LEGAJADA 17/01/2023 18:46:53 19/01/2023 11:22:15 Error 235-2023-000271 014494369170 Regularized 18/01/2023 18:30:04 235-2023-000247 014494369214 LEGAJADA 17/01/2023 18:46:53 18/01/2023 11:22:14 Ok 235-2023-000268 014494369214 Regularized 18/01/2023 18:30:04 235-2023-000438 014494377323 LEGAJADA 30/01/2023 19:20:42 31/01/2023 12:18:38 Ok 235-2023-000466 014494377323 Regularized 31/01/2023 23:03:30 235-2023-000821 014494394521 LEGAJADA 21/01/2023 18:38:23 22/02/2023 16:16:00 Ok 235-2023-000840 014494394521 Regularized 22/02/2023 17:12:41 In addition to this, the calculated measure of how many errors there are. In this case, it should show 2 on the visual card I will place.
Thanks again.
