Forum Discussion
Basdo
3 years agoFrequent Visitor
Filter Column based on values from other column
Hi, I have data of this format Key ID A 1 A 2 A 3 B 3 B 4 C 5 D 6 E 6 E 7 Now I would like to filter by all IDs that are "connected" with eachot...
Anonymous
3 years agoNot applicable
Hi Basdo,
In fact, the grouping rules that you mentions are hard to reproduce the group information in your sample table.
AFAIK, power bi data mode tables do not include row and column index. For this scenario, you can simply add tag to table to confirm if the specific category has continuous records. They will need to be coding complex conditions to check and exclude specific records.
Regards,
Xiaoxin Sheng