Forum Discussion
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 Admis...
parry2k As suggested, I have added the details. Please let me know if you required anymore details.
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 )