Forum Discussion

kevinedora's avatar
kevinedora
Helper I
2 years ago
Solved

Duplicate Identifier

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 m...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    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")
     
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

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")