Help - Find date difference between date columns from different tables

[latheesh89]

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

[parry2k]

@latheesh89 read this post to get your answer quickly

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[latheesh89]

@parry2k  As suggested, I have added the details. Please let me know if you required anymore details.

[parry2k]

@latheesh89 so you are looking for difference between event date and admission date?

add a new columna as below

# of Days = DATEDIFF( Table[Admission Date], Table[Event Date], DAY )