Forum Discussion
Relationship with Dates
In order to have "Age group" for my data set, i've created a help table with "birthday" as unique dates. But when i try to link it to birthday, i keep telling me it's not unique. Any1 knows why...
GilesWalker i'm unable to see the bottom from data view or query view as it's too many rows.
Although i really think you should handle this with measures. You can easily calculate an age with DATEDIFF() and evaluate it to determine the corresponding age group.