Forum Discussion
RaMa87
Jul 23, 2021Copper Contributor
Custom Filter function
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 alr...
RaMa87
Jul 23, 2021Copper Contributor
Hi Nikolino,
thanks for the answer - in retrospective my wording was maybe not correct. I want to keep all lines which are listed more than 2 times, i.e. delete all entries with only one or two lines. So keep everything =>3 and delete the others --> so the problem is that I do not simply need to delete individual entries.
The filter would also need to be within Power BI (i.e. the query I set up) otherwise it will make the whole automated output useless.
thanks for the answer - in retrospective my wording was maybe not correct. I want to keep all lines which are listed more than 2 times, i.e. delete all entries with only one or two lines. So keep everything =>3 and delete the others --> so the problem is that I do not simply need to delete individual entries.
The filter would also need to be within Power BI (i.e. the query I set up) otherwise it will make the whole automated output useless.
NikolinoDE
Jul 23, 2021Platinum Contributor
Regarding Power BI, unfortunately I can't help you. My knowledge in this area is very limited.
Maybe, one of the specialists here who are very familiar with Power BI could help you.
I wish you continued success with Excel
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Maybe, one of the specialists here who are very familiar with Power BI could help you.
I wish you continued success with Excel
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)