Forum Discussion
Dates not linking
This is an issue with circular relationships, not anything to do with the date field itself. However you've set up your schema, it's created a situation where there's ambiguity between tables. You'll need to reevaluate your relationship map to eliminate this.
Unforunately, we probably can't help you unless you post significantly more info, which might be propritary. Could you create a PBIX with sample tables?
Are the dates classified as one of the Date datatypes, or are they formatted as text?
It would also be helpful to post a (scrubbed) sample of two of the tables you're trying to connect, and the specific error message you're recieving.
I added a date column in each table and included a formula "eomonth".
These are the filters I require in the dashboard.
This is the relationship I created for all the filters
Here is the matrix to check if the data is correct. The totals are correct but the monthly data is incorrect.
If I try to create more relationship I receive this error message
This is an issue with circular relationships, not anything to do with the date field itself. However you've set up your schema, it's created a situation where there's ambiguity between tables. You'll need to reevaluate your relationship map to eliminate this.
Unforunately, we probably can't help you unless you post significantly more info, which might be propritary. Could you create a PBIX with sample tables?