Variable Goals

[Anonymous]

I am attempting to build sales goals into a dashboard. The issue is that my goals table does not have any unique values that can be tied to another table. 

Sales Rep|Month(as the date of the 1st of the month)|Daily Goal

Each month the goal is adjusted based on the previous month if needed. This means that the goal table must have a goal for every rep for every month (each rep has 12 lines on the table). Any suggestions how to get this into a column or a measure on my dashboard that will relate to my other data? 

[Anonymous]

Hi @Anonymous ,

Can you provide a sample data for the two tables you are trying to link?