Forum Discussion

FrancescoSCP's avatar
FrancescoSCP
Helper IV
5 years ago

Data modeling with different granularity

Hi all, i have troubles with modeling in power bi with different granularities.   I have two fact tables: 1) Quantity: the table has item_key and qty; 2) Times: the table has model_key, project_...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, FrancescoSCP 

 

It’s my pleasure to answer for you.

According to your description,You need to create relationships between tables(If the column names and data types are the same,PBIwill automatically create a relationship),then you can use them in visuals.

Measure is not restricted by the table,so as long as you perfect the relationship between tables, you can easily create measures for different tables.

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

FrancescoSCP's avatar
FrancescoSCP
Helper IV
5 years ago

Hi Janey,

 

yes i know that i have to create the relationships between the tables and measure is not restricted by the table.

The question is how to model this.

 

Regards,
Francesco

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, FrancescoSCP 

     

    It depends on your data and what you want to show.You need to connect to the data sources,then create relationships,then create measures, then create visuals.

    Which link did you have a problem with?

    Could you mind providing some sample data and desired results?

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.