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...
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
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 )