Help with relationship ambiguity

[jakeryan56]

Hi, I've tried to create a monthly targets table which has a relationship to my sales, NPS and timesheet data so the user can simply select the month name and staff from the slicer in the report and it will shows the sales data as well as the targets for that period. I am just coming accross a problem creating relationships and need help as I am having problems creating direct relationships as it is creating ambiguity. Any ideas on the next steps?

[v-yulgu-msft]

Hi @jakeryan56,

I am not clear about your problem. Would you please post some necessary sample data of each related table? Please illustrate your requirement with examples to help me better understand.

Regards,

Yuliana Gu