Forum Discussion
Create list based on multiple customer IDs
So my data would look something lije this, but the I have added the yellow column. I would need to tell Power BI which customers are in Group A and B, and ignore everything else. I will then be reporting on the two groups sales performances, but I am only interested in their data. So I need to create a gropu or a list in Power BI to do this.
This is how I would do it in Excel for example. There are around 1,000 customers that I need to group like this, so I was hoping there would be a quick/simple way! Thanks
That data is not in a usable format. Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
