Forum Discussion
Solved
Remove dublicates, keep value based on another column
Hi, I have a table with all operations on a production order. I could like to remove all duplicates BUT keep the latest operation. For example: Rows marked with purple is the one I would like t...
Hi
You can create a measure that filters the data depending on the operation no. and then checks if the selected date is the latest. I've done it like this:You can then add this measure to your table or just use it as a filter. This will only keep the latest dates for each production order no.:
Hope this helps.
Best regards.
Hi
You can create a measure that filters the data depending on the operation no. and then checks if the selected date is the latest. I've done it like this:
You can then add this measure to your table or just use it as a filter. This will only keep the latest dates for each production order no.:
Hope this helps.
Best regards.
Thank you! It worked 🙂