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.

ConorHG's avatar
ConorHG
Helper I
8 years ago

Hi FarhanAhmed1984, 

 

All my date columns are in the correct format. 

 


Thanks, 
Conor.

FarhanAhmed1984's avatar
FarhanAhmed1984
Resolver III
8 years ago

Try this.

 

No Bed Days = DateDiff(FIRSTDATE('Hipe Data'[AdmDate]),FIRSTDATE('Hipe Data'[DisDate]),DAY)

 

DateDiff takes Scalar as Input, so you need to have 1 value return for each input.


You may use MAX() or MIN() as well instead of FIRSTDATE