- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-11-2024 01:07 AM | |||
07-09-2024 09:16 AM | |||
10-09-2023 09:42 PM | |||
07-28-2023 08:29 AM | |||
02-06-2024 05:50 AM |
User | Count |
---|---|
141 | |
115 | |
82 | |
63 | |
48 |