Hi Guys - Newbie here. I want to preface this by saying that I did attempt to find the answer on my own before I reached out for help but I was unable to find the solution to my issue.
I created a date table to use to link to my fact tables. When I attempt to create the relationship it won't let me because it is saying that both columns have duplicate values. I know this isn't true in regards to my date table "primary key" column because I've checked and rechecked this column by attempting to remove duplicates with each time excel saying "no dupes found".
I thought I had located the problem at one point because the column was formatted with a preceding asterisk date (the dates that change by the day, etc.). But even when I re-formatted it that still didn't solve the problem.
What am I missing???
I'm about to pull my hair out!
**I created this date table on my own since I couldn't find one that was easily downloadable. Microsoft has one supposedly in a "Contoso" sample workbook but it is off of 2010 and I can't open the managed tables since I'm working off of 2013. There was another one on some site but it was get downloaded in the format I needed. It was in some sort of "feed" - way out of the scope of my knowledge.
**Also, I did start with 1/1/1900 which shouldn't have made a difference but thought I'd put that out there. I just typed in the first date and copied/dragged down the rest.
Thanks for your help! Any assistance would be most appreciated.
I created a date table to use to link to my fact tables. When I attempt to create the relationship it won't let me because it is saying that both columns have duplicate values. I know this isn't true in regards to my date table "primary key" column because I've checked and rechecked this column by attempting to remove duplicates with each time excel saying "no dupes found".
I thought I had located the problem at one point because the column was formatted with a preceding asterisk date (the dates that change by the day, etc.). But even when I re-formatted it that still didn't solve the problem.
What am I missing???
I'm about to pull my hair out!**I created this date table on my own since I couldn't find one that was easily downloadable. Microsoft has one supposedly in a "Contoso" sample workbook but it is off of 2010 and I can't open the managed tables since I'm working off of 2013. There was another one on some site but it was get downloaded in the format I needed. It was in some sort of "feed" - way out of the scope of my knowledge.
**Also, I did start with 1/1/1900 which shouldn't have made a difference but thought I'd put that out there. I just typed in the first date and copied/dragged down the rest.
Thanks for your help! Any assistance would be most appreciated.
