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

     
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

    • 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