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!