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.

ConorHG's avatar
ConorHG
Icon for Helper I rankHelper I
8 years ago

When I create the relationship I get the error in my initial post but if I delete the relationship, the calc works perfectly as it is in the initial post. 

The calc isn't using any of the fields from the DateTable just columns from the FactsTable. 

 

So I don't understand what the relationship is doing to stop "'Hipe Data'[DisDate].[Date]" from working when it worked before the relationship? 

 

Appreciate your patience!
Conor.

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

    Thanks FarhanAhmed1984 think I kind of understand it now.