Create list based on multiple customer IDs

Hi all!   I have a list of over 50k customers, but I am only concerned with aprox 1k of them - group A and Group B.  I don't have access to the data in Excel format - I've linked Power BI directly ...