This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How do I use pivot tales to show where unique client refs are appearing more than once for each date?
| Date of intervention | Unique Client Ref |
|---|---|
| 22/12/2024 | M-41430 |
| 22/12/2024 | M-40993 |
| 22/12/2024 | M-37264 |
| 22/12/2024 | M-52236 |
| 22/12/2024 | M-41430 |
| 22/12/2024 | M-37600 |
| 22/12/2024 | M-20262 |
| 22/12/2024 | M-21813 |
| 23/12/2024 | M-40670 |
| 23/12/2024 | M-37264 |
| 23/12/2024 | M-37264 |
| 23/12/2024 | M-35885 |
| 23/12/2024 | M-30455 |
| 23/12/2024 | M-24745 |
| 23/12/2024 | M-37910 |
| 24/12/2024 | M-34321 |
| 24/12/2024 | M-23928 |
| 24/12/2024 | M-37264 |
| 24/12/2024 | M-20249 |
| 24/12/2024 | M-28356 |
| 24/12/2024 | M-37910 |
| 24/12/2024 | M-49791 |
| 25/12/2024 | M-41430 |
| 25/12/2024 | M-47883 |
| 25/12/2024 | M-20159 |
| 25/12/2024 | M-35885 |
| 25/12/2024 | M-34321 |
| 26/12/2024 | M-37910 |
| 26/12/2024 | M-34321 |
| 26/12/2024 | M-24745 |
| 26/12/2024 | M-57492 |
| 26/12/2024 | M-34321 |
| 26/12/2024 | M-34321 |
| 26/12/2024 | M-44263 |
| 27/12/2024 | M-37264 |
| 27/12/2024 | M-41430 |
| 27/12/2024 | M-34321 |
| 27/12/2024 | M-52236 |
| 27/12/2024 | M-57492 |
| 28/12/2024 | M-36748 |
| 28/12/2024 | M-28473 |
| 28/12/2024 | M-24807 |
| 28/12/2024 | M-34321 |
| 28/12/2024 | M-40670 |
| 28/12/2024 | M-40670 |
| 28/12/2024 | M-41430 |
| 28/12/2024 | M-34321 |
| 29/12/2024 | M-19485 |
| 29/12/2024 | M-34321 |
| 29/12/2024 | M-58254 |
| 29/12/2024 | M-18078 |
| 29/12/2024 | M-14602 |
| 29/12/2024 | M-28473 |
| 29/12/2024 | M-35885 |
| 29/12/2024 | M-28473 |
| 29/12/2024 | M-36748 |
| 29/12/2024 | M-40670 |
| 29/12/2024 | M-28473 |
| 29/12/2024 | M-39999 |
| 30/12/2024 | M-18078 |
| 30/12/2024 | M-36748 |
| 30/12/2024 | M-11377 |
| 30/12/2024 | M-35885 |
| 30/12/2024 | M-11575 |
| 30/12/2024 | M-11575 |
| 30/12/2024 | M-37434 |
| 30/12/2024 | M-36748 |
| 30/12/2024 | M-30455 |
| 30/12/2024 | M-24745 |
| 31/12/2024 | M-23928 |
| 31/12/2024 | M-35992 |
| 31/12/2024 | M-38679 |
| 31/12/2024 | M-35736 |
| 31/12/2024 | M-37264 |
| 31/12/2024 | M-30974 |
| 31/12/2024 | M-24745 |
| 31/12/2024 | M-34321 |
| 01/01/2025 | M-40667 |
| 01/01/2025 | M-10170 |
| 01/01/2025 | M-14470 |
| 01/01/2025 | M-58270 |
| 01/01/2025 | M-18333 |
| 01/01/2025 | M-35424 |
| 01/01/2025 | M-36748 |
| 01/01/2025 | M-37264 |
| 01/01/2025 | M-10170 |
| 01/01/2025 | M-11377 |
| 01/01/2025 | M-28473 |
| 01/01/2025 | M-47240 |
| 01/01/2025 | M-41811 |
| 01/01/2025 | M-10191 |
| 01/01/2025 | M-40670 |
| 01/01/2025 | M-13533 |
| 01/01/2025 | M-38597 |
| 01/01/2025 | M-11377 |
| 01/01/2025 | M-14146 |
| 01/01/2025 | M-11575 |
| 01/01/2025 | M-10170 |
| 02/01/2025 | M-37910 |
| 02/01/2025 | M-39170 |
| 02/01/2025 | M-35424 |
| 02/01/2025 | M-37264 |
| 02/01/2025 | M-28473 |
| 02/01/2025 | M-32142 |
| 02/01/2025 | M-37264 |
| 02/01/2025 | M-40705 |
| 03/01/2025 | M-10170 |
| 03/01/2025 | M-10191 |
| 03/01/2025 | M-55072 |
| 03/01/2025 | M-35885 |
| 03/01/2025 | M-57492 |
| 03/01/2025 | M-55072 |
| 03/01/2025 | M-14602 |
| 03/01/2025 | M-20264 |
| 03/01/2025 | M-28489 |
| 03/01/2025 | M-43548 |
| 03/01/2025 | M-38517 |
| 03/01/2025 | M-19879 |
| 03/01/2025 | M-50348 |
| 03/01/2025 | M-37264 |
| 03/01/2025 | M-28148 |
| 03/01/2025 | M-30426 |
| 03/01/2025 | M-28489 |
| 03/01/2025 | M-20249 |
| 03/01/2025 | M-10170 |
| 03/01/2025 | M-41274 |
| 03/01/2025 | M-20249 |
| 03/01/2025 | M-19879 |
| 03/01/2025 | M-20264 |
| 04/01/2025 | M-40940 |
| 04/01/2025 | M-57889 |
| 04/01/2025 | M-28489 |
| 04/01/2025 | M-40667 |
| 04/01/2025 | M-52236 |
| 04/01/2025 | M-36748 |
| 05/01/2025 | M-18994 |
| 05/01/2025 | M-17428 |
| 05/01/2025 | M-36748 |
| 05/01/2025 | M-18994 |
| 05/01/2025 | M-37264 |
| 05/01/2025 | M-20679 |
| 05/01/2025 | M-31389 |
| 05/01/2025 | M-35885 |
| 06/01/2025 | M-14340 |
| 06/01/2025 | M-19055 |
| 06/01/2025 | M-52254 |
| 06/01/2025 | M-12620 |
| 06/01/2025 | M-10692 |
| 06/01/2025 | M-10191 |
| 06/01/2025 | M-28473 |
| 06/01/2025 | M-39488 |
| 06/01/2025 | M-36748 |
| 06/01/2025 | M-41383 |
| 06/01/2025 | M-43069 |
| 06/01/2025 | M-12323 |
| 06/01/2025 | M-20321 |
| 06/01/2025 | M-28489 |
| 06/01/2025 | M-40705 |
| 06/01/2025 | M-10428 |
| 06/01/2025 | M-30426 |
| 06/01/2025 | M-37264 |
| 06/01/2025 | M-12620 |
| 06/01/2025 | M-57492 |
| 06/01/2025 | M-32142 |
| 06/01/2025 | M-11575 |
| 06/01/2025 | M-30426 |
| 06/01/2025 | M-12620 |
| 06/01/2025 | M-41094 |
| 06/01/2025 | M-11575 |
| 06/01/2025 | M-41094 |
| 06/01/2025 | M-37264 |
| 06/01/2025 | M-55004 |
| 06/01/2025 | M-11575 |
| 06/01/2025 | M-37264 |
| 06/01/2025 | M-30426 |
| 07/01/2025 | M-10191 |
| 07/01/2025 | M-37264 |
| 07/01/2025 | M-12620 |
| 07/01/2025 | M-57492 |
| 07/01/2025 | M-37264 |
| 07/01/2025 | M-38541 |
| 07/01/2025 | M-35424 |
| 07/01/2025 | M-40993 |
| 07/01/2025 | M-28473 |
| 07/01/2025 | M-14191 |
| 07/01/2025 | M-38541 |
| 07/01/2025 | M-12323 |
| 07/01/2025 | M-28489 |
| 07/01/2025 | M-40952 |
| 07/01/2025 | M-14191 |
| 07/01/2025 | M-37264 |
| 07/01/2025 | M-41094 |
| 08/01/2025 | M-36748 |
| 08/01/2025 | M-40952 |
| 08/01/2025 | M-37264 |
| 08/01/2025 | M-37434 |
| 08/01/2025 | M-52236 |
| 08/01/2025 | M-23928 |
| 08/01/2025 | M-40952 |
| 08/01/2025 | M-10191 |
| 08/01/2025 | M-10170 |
| 08/01/2025 | M-11575 |
| 08/01/2025 | M-12620 |
| 09/01/2025 | M-37434 |
| 09/01/2025 | M-40952 |
| 09/01/2025 | M-12620 |
| 09/01/2025 | M-40952 |
| 09/01/2025 | M-41094 |
| 09/01/2025 | M-10191 |
| 09/01/2025 | M-20722 |
| 09/01/2025 | M-10191 |
| 09/01/2025 | M-37264 |
| 09/01/2025 | M-10170 |
| 09/01/2025 | M-24807 |
| 09/01/2025 | M-28489 |
| 09/01/2025 | M-18078 |
| 09/01/2025 | M-52236 |
| 09/01/2025 | M-38541 |
| 09/01/2025 | M-12323 |
| 09/01/2025 | M-40993 |
| 09/01/2025 | M-18994 |
| 09/01/2025 | M-37264 |
| 10/01/2025 | M-37434 |
| 10/01/2025 | M-37264 |
| 10/01/2025 | M-36408 |
| 10/01/2025 | M-10191 |
| 10/01/2025 | M-37434 |
| 10/01/2025 | M-36748 |
| 10/01/2025 | M-12433 |
| 10/01/2025 | M-41587 |
| 10/01/2025 | M-52236 |
| 10/01/2025 | M-58376 |
| 11/01/2025 | M-52236 |
| 11/01/2025 | M-30426 |
| 11/01/2025 | M-35736 |
| 11/01/2025 | M-23928 |
| 11/01/2025 | M-21527 |
| 11/01/2025 | M-28489 |
| 11/01/2025 | M-36748 |
| 11/01/2025 | M-57492 |
| 11/01/2025 | M-36900 |
| 12/01/2025 | M-34334 |
| 12/01/2025 | M-18218 |
| 12/01/2025 | M-40993 |
| 12/01/2025 | M-14191 |
| 12/01/2025 | M-55590 |
| 12/01/2025 | M-33757 |
| 12/01/2025 | M-36748 |
| 12/01/2025 | M-52236 |
| 12/01/2025 | M-52236 |
| 12/01/2025 | M-58380 |
| 12/01/2025 | M-38233 |
| 12/01/2025 | M-18218 |
| 13/01/2025 | M-37264 |
| 13/01/2025 | M-10191 |
| 13/01/2025 | M-30426 |
| 13/01/2025 | M-57492 |
| 13/01/2025 | M-23986 |
| 13/01/2025 | M-10191 |
| 13/01/2025 | M-36748 |
| 13/01/2025 | M-11575 |
| 13/01/2025 | M-35736 |
| 13/01/2025 | M-52236 |
| 13/01/2025 | M-40362 |
| 13/01/2025 | M-38541 |
| 13/01/2025 | M-31567 |
| 13/01/2025 | M-52236 |
| 13/01/2025 | M-43069 |
| 13/01/2025 | M-28489 |
| 13/01/2025 | M-52236 |
| 13/01/2025 | M-24745 |
| 13/01/2025 | M-36748 |
| 13/01/2025 | M-37910 |
| 13/01/2025 | M-55572 |
| 13/01/2025 | M-17747 |
| 13/01/2025 | M-35736 |
| 13/01/2025 | M-10170 |
| 13/01/2025 | M-41548 |
| 13/01/2025 | M-20264 |
| 13/01/2025 | M-35885 |
| 13/01/2025 | M-36748 |
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Pull the Client Ref into the Rows section, the Date into the Values section and change the aggreation to count.
Set a filter to Count > 1.
If you want to see the dates, load the data into the Data Model and add a measure using CONCATENATEX. https://learn.microsoft.com/en-us/dax/concatenatex-function-dax
Andreas.