Forum Discussion

dennisdepoorter's avatar
dennisdepoorter
Helper I
7 years ago

Split one row into two rows

Hi All,   I have an issue, and don't know if it is even possible:   We have some products we sell and some combination of products we sell. For a production dashboard, I have to split some combi...
Need Help
dennisdepoorter's avatar
dennisdepoorter
Helper I
7 years ago

Can someone help me out here... still stuck.

 

So what is the problem:

 

  • We have 10 different products
    • ACN Cream
    • ACN+ Cream
    • ACN Wash
    • ACN+ Wash
    • SKN Wash
    • SKN Body Cream
    • SKN Face Cream
    • SKN Hydra + Face Cream
    • VGN Wash
    • FNG Spray
  • We also have 2 products that are a combination of 2 of our 10 products
    • ACN Therapy
      • ACN Wash
      • ACN Cream
    • ACN+ Therapy
      • ACN+ Wash
      • ACN+ Therapy

 

We want to have a production report, but in the data we get from Salesforce, it's not possible to split up the Therapy boxes again in single products. Therefore, I hope there is another way to do it. We want to split up every ACN Therapy and ACN+ Therapy again in the single products so we know what we have to produce when.

 

Stachusuggested to do it with a query, but I'm stuck there. So can someone help me out

 

 

I made a test environment with test data: TEST Environment

 

 

THANKS!!!!

dennisdepoorter's avatar
dennisdepoorter
Helper I
7 years ago

As I didn't get any clear answer to my problem... I think it's not possible in powerBI... correct me if I'm wrong, but I just hit the powerBI-wall :smileyfrustrated:

 

Because it's possible in Einstein Analytics (Salesforce Wave Analytics), I'm considering to make the switch to Einstein Analytics because of its functionalities, and less limitations then powerBI. Still hope someone comes up with a solution for my problem.

 

Best regards,

Dennis

 

 
 
  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    it's not really a PowerBI wall - it's possible, but requires changes in your model (at least based on your explanation)

    you work with Salesforce data so tool customised for Salesforce most likely it will be better match for you, especially if it  has access to some product flags hidden for PowerBI