Forum Discussion
Split one row into two rows
that's because the relation between 'Order Product' and 'Product Component' is many to many
what I had in mind is expanding the 'Order Product' table to only contain singles, that means there is only relation with Product, which is 1:many, and 'Product Component' doesn't have to loaded to the model at all
The problem is,... al that data comes out of Salesforce, so I don't think / know it's that easy???
it's imported model, right? if so then you can do pretty much anything with the data - add custom columns, remove unnecessary columns etc.
the only question is performance of the refresh (doesn't affect the end user though)Hi Stachu,
I tried to fix it like you told with a querie, but it just didn't worked out (I have no knowledge about queries in PowerBI so fare... )
If it helps for you, I have a test inviroment of the database online:
You can find the test environment here (dropbox): Test environment
Can you / someone have a look please?
Thanks!!!
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
- 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!!!!
- We have 10 different products
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
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