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...
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

     

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