Forum Discussion
Data Relationship
Good Evening, i have two sets of data on my BI and for some reason i can not get the data realtionship to work right. the data has come from a campaign dailler report blending in the site absenc...
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
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 🙂