Forum Discussion

ConorHG's avatar
ConorHG
Icon for Helper I rankHelper 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
Icon for Resolver III rankResolver III
8 years ago

Looks like disdate is not a Date Column.

 

- Click on field.

- Click on Modelling tab

- See if data type is Date , change it to date if it is not.

.

 


Thanks