Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

remove duplicate in column

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

Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    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

     

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    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's avatar
      v-diye-msft
      Community Support
      7 years ago

      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