Forum Discussion

ConorHG's avatar
ConorHG
Helper I
8 years ago
Solved

Date Relationship

Hi,    I am struggling with doing a date relationship.  I have created a calendar table and added several columns.    In both data view and query editor, I have put the dates I am doing the rela...
Need Help
  • FarhanAhmed1984's avatar
    FarhanAhmed1984
    8 years ago

    I think since you are creating relationship of disdate and date table using date column that's why you are limiting the capabilities of date data. Therefore if you need to have all the capabilities for date values (hierarchy) then you should create a DateKey (Integer Value) on both tables and then join it on that. After that you will see all the hierarchy for your date values.

FarhanAhmed1984's avatar
FarhanAhmed1984
Resolver III
8 years ago

I think since you are creating relationship of disdate and date table using date column that's why you are limiting the capabilities of date data. Therefore if you need to have all the capabilities for date values (hierarchy) then you should create a DateKey (Integer Value) on both tables and then join it on that. After that you will see all the hierarchy for your date values.

ConorHG's avatar
ConorHG
Helper I
8 years ago

Thanks FarhanAhmed1984 think I kind of understand it now.