Forum Discussion

mike_newbs's avatar
mike_newbs
Frequent Visitor
3 years ago
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...
Need Help
  • DataVitalizer's avatar
    DataVitalizer
    3 years ago

    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

     
DataVitalizer's avatar
DataVitalizer
Super User
3 years ago

Would this output answer your need? (I kept only two customers for the example)

 

CustomerProductLocation
Customer 1Product AResidential
Customer 1Product ARetail
Customer 1Product ASchool
Customer 1Product AHospital
Customer 1Product BResidential
Customer 1Product BRetail
Customer 1Product BSchool
Customer 1Product BHospital
Customer 1Product CResidential
Customer 1Product CRetail
Customer 1Product CSchool
Customer 1Product CHospital
Customer 1Product DResidential
Customer 1Product DRetail
Customer 1Product DSchool
Customer 1Product DHospital
Customer 2Product AResidential
Customer 2Product ARetail
Customer 2Product AHospital
Customer 2Product DResidential
Customer 2Product DRetail
Customer 2Product DHospital
mike_newbs's avatar
mike_newbs
Frequent Visitor
3 years ago

I am looking for something more like:

 

ProductsNumber of sellers
Product A3
Product B2
Product C3
Product D2

 

Kind regards

 

Michael

  • DataVitalizer's avatar
    DataVitalizer
    Super User
    3 years ago

    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

     
      • DataVitalizer's avatar
        DataVitalizer
        Super User
        3 years ago

        I am glad I was able to help