Duplicate Identifier

[kevinedora]

Hi,

Need help, i need to identify a duplicate within a date range. Below table is an example, i wanted to know if last month (June) if i have a duplicate ID and category = "Charged" then I want my tagging to be duplicate so I can exclude that ID from last month.

Date	ID	Category
06/13/2024	12344	Charged
06/14/2024	12345	No
07/01/2024	12344	No Charge
07/08/2024	12345	No Charge

Desired Result:

Date	ID	Category	Tagging
06/13/2024	12344	Charged	Duplicate
06/14/2024	12345	No	no
07/01/2024	12344	No Charge	no
07/08/2024	12345	No Charge	Original

I'll greatly appreciate if this can be dynamic as well since I have 1 year worth of data.

[Ray_Minds]

Hi @kevinedora 
Duplicate Values = CALCULATE(COUNT('Sheet1 (2)'[Section]),FILTER('Sheet1 (2)','Sheet1 (2)'[Section]= EARLIER('Sheet1 (2)'[Section])))

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

[ryan_mayu · Accepted solution]

@kevinedora 

you can try this

Column =

var _check=maxx(FILTER('Table','Table'[Date]>EOMONTH(EARLIER('Table'[Date]),0)&&'Table'[Date]<=EOMONTH(EARLIER('Table'[Date]),1)&&'Table'[ID]=EARLIER('Table'[ID])),'Table'[Date])

return if('Table'[Category]="Charged"&&not(ISBLANK(_check)),"Duplicated")