Date table relationship issues

I’m desperate. I’ve been working on this for two days.

I’m working on a project that has one table connected to an sql table with an import connection (not direct query). That table contains several date fields with non-continuous dates.

To normalize my data, I created a date table using autodate. Everything worked great until I got to a point in the project where I need to make calculations using fields in both tables.

I created a relationship between the tables and tried to select one to many, but because of duplicate data and a circular error I can only select many to one.

I have tried:

  • building the columns and measures I need within the date table and the sql table
  • I deleted my autodate table and built a direct query date table in power query

Nothing works. There is clearly something wrong with the table relationship.

Help!