Forum Discussion
Data Relationship
Hi Anonymous
You can try to create a dimtable as:
Dimtable = CALENDAR(MIN('Table'[Date],MAX('Table'[Date]))About many-to-many relationship, you can refer:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-many-to-many-relationships
Best Regards,
Link
Ok, the relationship columns look good. But you are using a many to many relationship.
You should avoid many to many relationships until you really need them because this can cause wrong results. Check out this blog article about ambiguity with many to many relationships.
Can you use dimensional tables for your data model?
I know it's a little work at the beginning to read into the topic, but you should get an idea about fact and dimension tables. Maybe check this article to get an idea about fact and dimension tables.
If you need any help please let me know.
If I answered your question I would be happy if you could give it a thumbs up 👍!
Best regards
Denis
thankyou selimovd
If i attempt to change the relationship i cant save the amend. it only seems to accept Many to Many
Yes, you cannot just change the relationship as you don't have unique values in either of the tables.
That's the reason you should create dimensional tables. Check the article I posted in my last answer 🙂