Forum Discussion
Resolver INo correspondence between table information
Hello,
I am looking from a customer list to find the selling prices of the corresponding items.
Here are my tables with their relationships to make it easier to understand:
For each PRO_REFCONST - Copy (my first table) corresponds an ELC_MNTHT (last table) and this for each CLIENT ID.
The concern I have is that when I create my visual I don't get the correct amounts in front of each row.
Would you have an idea please ?
thank you by advance,
Alexis
That's not a data model - they usually expect dimension tables and fact tables with 1:* relationships, ideally resulting in a snowflake layout. If you have multiple fact tables then they should be controlled via dimensions, and not by each other.
Can you decide which of your tables are dimensions and which are facts?
3 Replies
- lbendlin
Super User
That's not a data model - they usually expect dimension tables and fact tables with 1:* relationships, ideally resulting in a snowflake layout. If you have multiple fact tables then they should be controlled via dimensions, and not by each other.
Can you decide which of your tables are dimensions and which are facts?
Hi AlexisPREVOT ,
You can convert your data model into a star model or a snowflake model.
Star Schema vs Snowflake Schema
https://debbiesmspowerbiazureblog.home.blog/2020/06/17/power-bi-models-snowflake-to-star-schema/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AlexisPREVOTHi Anonymous and lbendlin ,
Thank you for your answers.
I'm going to try to do the star schema but I feel like I only have fact tables so I'm going to have to try transforming them to make it work.
Thank you again for your help
