Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Relationships between groups

Hey, I have a data set looking like screenshot following, but I have met a wall, and I know this is simple cut cannot conceptualise this: In my set, an order can come from several sources: adwor...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    Anonymous so you should unpivot the data by following these steps:

     

    Transform Data -> Select Order id and pK_Date columns -> Right click -> Unpivot other columns

     

    It will add two columns, attribute and value, rename as you want it, close, and apply.

     

    Now set the relationship from the dim table to the attribute column in the fact table and that's it. Now you should be able to slicer the fact table from the dim table

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Anonymous  

Thanks for parry2k's concern about this issue.

parry2k's method is correct.


Based on the dataset you provided, first you should hold Ctrl and do a multi-select of the OrderID and PK_Date columns in PowerQuery Editor:


Then select Unpivoted other columns:

 

And the result should look like this, not like your result:

And then close&reply.

 

Create a relationship between this table and your table dim_team:

 

 

You can then add a Slicer for data filtering:

 

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.