How to find the Duplicate in a Date Range

[Anonymous]

Hi team,

Please note my sample data !

TAF_START_DATE	TAF_END_DATE	STORE_NUMBER	ITEM_CODE	TAF	Stuts	Duplicate
22-05-2019 00:00	18-06-2019 00:00	61	1000438	1.01	1
22-05-2019 00:00	18-06-2019 00:00	62	1000438	1.01	1
23-05-2019 00:00	30-06-2019 00:00	62	1000438	1.01	1	Yes
22-05-2019 00:00	18-06-2019 00:00	821	1000438	1.01	1

Here i need to find the overlapping duplicates in the data.

That is any item's are having duplicate TAF.See here the example Taf starting from 22-05-19 and ending 18-06-2019 and another taf is starting 23-05-2019 and ending 30-06-2019.That means the period is overlapping and its duplicated.Any idea to find the duplicates in this scenario.

[v-yuta-msft · Accepted solution]

@Anonymous ,

Create a calculate column using DAX below:

Duplicate = IF(CALCULATE(COUNT('Table'[TAF_START_DATE]), ALLEXCEPT('Table', 'Table'[TAF_START_DATE])) > 1, "Yes", "No")

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-yuta-msft ,

This is not works...The first one also showing 'Yes'

I have to find in between the data range.

Thank you for your time..