Forum Discussion
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_...
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
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.