Jul 23 2021 06:46 AM
Hi guys,
I am looking for a custom filter function
A1 | 1 | 2 |
A2 | 1 | 2 |
A3 | 1 | 2 |
A1 | 1 | 2 |
A4 | 1 | 2 |
A1 | 1 | 2 |
A2 | 1 | 2 |
A2 | 1 | 2 |
I have sth similar to above table already in Power BI. What I am now looking for is a filter that searches the first column (combination of text and numbers) and removes all lines which are listed less than 2 times. SO in the above example I would need to get rid of the following lines:
A1 | 1 | 2 |
A2 | 1 | 2 |
A1 | 1 | 2 |
A1 | 1 | 2 |
A2 | 1 | 2 |
A2 | 1 | 2 |
It might be very easy but I can't think of a smart solution at the moment. Does anyone have an idea how to do this?
Thanks and cheers
Jul 23 2021 07:15 AM
If I understand the translation correctly, look for a way to keep duplicates and delete individual entries.
If so, here is an example with VBA in the inserted file.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jul 23 2021 07:27 AM
Jul 23 2021 07:33 AM
Jul 23 2021 07:47 AM
Jul 23 2021 08:48 AM