Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Easy Modelling Question (Hard to word)

Hello! I have a question about how to build my model. Given data provides a bunch of suppliers, who have 1, 2 or 3 processes of creating the product. My question is: What is the best way (how woul...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

selimovd 

I can adapt that for what is best. That is why I am asking. 
currently there is a column for every process possible. It feels like there is a better way to connect them. That is what i need help with. Which connection will be the easiest to work with when building my model?

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

for me Process and Supplier seem to be dimensions.

So I would use them both as they are as dimensional tables and add a fact table, that brings them together.

Take a look at the following article about the differences:

Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table - RADACAD

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    selimovd 
    Thank you, this is sort of answer to my question. However, I need to be able to recommend a supplier that uses a certain method. How would I do that?