Forum Discussion
kasife
Helper V
Helper VData modeling suggestion
Guys, good afternoon! All good? I would like your opinion for a modeling issue, as I did it in a way that is bringing the correct result, but when placing the values in a matrix, the matrix gives a...
Hello kasife ,
Mainly dimension tables would have a relation one to many with the fact tables where the dim table is the one side.in your case, it's working many to many. I suggest you check the concept of star schema data modeling and build your model as it.
star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Idrissshatila
Super User
Super UserHello kasife ,
Mainly dimension tables would have a relation one to many with the fact tables where the dim table is the one side.in your case, it's working many to many. I suggest you check the concept of star schema data modeling and build your model as it.
star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
kasifeIdrissshatila Thanks so much