remove duplicate in column

[Anonymous]

so i have the following data

2333  11/01/19    in process

2333  18/01/19    in process

2333   25/01/19   in process

2333   1/02/19      won

2333   8/02/19      won

I want the result to be 

2333  11/01/19    in process

2333   1/02/19      won

removing all duplicated and as soon as its won stop repeating it

my table has

id         date         process

2333     1/2/19     inprocess

any help would be much appreciated

thanks

[v-diye-msft · Accepted solution]

Hi @Anonymous 

You can use below measure to filter the table:

new id = var a = CALCULATE(MIN(Table4[date]),ALLEXCEPT(Table4,Table4[process]))
Return
IF(MAX(Table4[date])=a,MAX(Table4[id]),BLANK())

Best regards,

Dina Ye

[v-diye-msft]

Hi @Anonymous ,

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye