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.