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
Hello Anonymous ,
can you do a double click on the relationship and check if the values of the two column that are connected are correct?
They should both look the same. Like both a date or an integer or the same text. You can also post a screenshot here if the data is not sensitive.
Best regards
Denis
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
Denisthankyou selimovd
If i attempt to change the relationship i cant save the amend. it only seems to accept Many to Many