Data Relationship

[Anonymous]

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 absence report. i would like to merge the data enabling me to cross the reports and return daily Timesheet hours. I have tried a realtionship between agent name and His_userfullname and a seprate one as His-calldate and timesheet date. 

unfortunatly i am not getting the results i need. Am i missing something stupid?

Do the relationships need to have the same title?

thanks in advance 

[v-xulin-mstf · Accepted solution]

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

[selimovd]

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

[Anonymous]

Good Afternoon

@selimovd 

The date formats appear to be the same

[selimovd]

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

[Anonymous]

thankyou @selimovd 

If i attempt to change the relationship i cant save the amend. it only seems to accept Many to Many

[selimovd]

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 🙂