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

Hi mike_newbs 

I need to understand something before I suggest a solution.

CustomerProductsLocations
Customer 1Product A; Product B; Product C; Product DResidential; Retail; School; Hospital

 

Does the above row mean Product A was sold in 4 locations, Product B was sold also in 4 locations and so on?

Did it work ?  👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

  • mike_newbs's avatar
    mike_newbs
    Frequent Visitor
    3 years ago

    Hello DataVitalizer 

     

    Apologies I wasn't clear.

     

    It means Customer 1 sells products A, B, C and D in residential, retail, School and hospital locations.

     

    Its counting how many products are sold, it is showing what products the customer are trained to sell and which locations they are trained to sell at.

     

    I hope that clarifies but please feel free to ask any other questions.

     

    Kind regards

     

    Michael

    • 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