Forum Discussion
My Date Table not working
Hi there, I have some data table with Year and Month columns, and I've set up a Date table. However the relationship isn't working, as the visual results only have data but without date in it. ...
Thank you for your reply.
I put the Year to Date column, however, I know Year is Whole number, but there is a Year column in Date table, so I thought it might work, unfortunately, it didn't
- christinepayton
Most Valuable Professional
The year column never needs to be a date type, I would make them whole number on both ends. But if your data is at the granularity of month, and you already have a year and month column in your fact table, I'm not sure why you're needing a date table at all? Is it to get the quarter? You might be better off with a date table that is at the month granularity and related on the month column if you're not using it for anything else.
