Forum Discussion
Solved
Organising cells with multiple data values
Hello I have recently started using Power Bi to summarise data on our partners. Below is a basic version how the data is extracted: Name Products Business locations Customer Products Lo...
If you want to reach this table start from the first one, and exclude the customer and location columns,
1. Split the Products column by rows
Group by the same column with the defaut config
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
I am looking for something more like:
| Products | Number of sellers |
| Product A | 3 |
| Product B | 2 |
| Product C | 3 |
| Product D | 2 |
Kind regards
Michael
If you want to reach this table start from the first one, and exclude the customer and location columns,
1. Split the Products column by rows
Group by the same column with the defaut config
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
Thank you DataVitalizer That worked perfectly.
I am glad I was able to help