Help - Find date difference between date columns from different tables

Dear Techie,

I have two fact tables (Census & Events) and they are connected to a common dimensions like Patient, Date. I want to create a measure that will give the date difference between Admission date (Census Fact) and Event date (Event Fact) in days.

Relationships:

Census             Date

Census Date*:1     Date

Event             Date

Event Date*:1     Date

Census       Patient

PatientKey PatientKey

Event          Patient

PatientKey  PatientKey

Example:

When I add Event Date and Admission Date for a particular patient, this is how the report looks. I want to add a measure next to this that should give the difference in days

I have tried many options but none is working. Can anyone please help me on this?

Thanks,

Latheesh