Forum Discussion
Solved
Date difference (separate columns in separate tables) based on a unique identifier
Hello everyone! I have 2 tables: "applications" and "funding" "applications" contains columns including a unique column of "application ID" and "application date" "funding" contains columns inc...
Hi TylerSimpson ,
Based on the information you provided I joined the Application and Funding tables on 'Application ID'
Then created the following column in application table (you can reverse it if you prefer it in the Funding table)
DateDiffCol = DATEDIFF(Applications[Application Date], RELATED(Funding[Funding Date]), DAY)
Then the following measure for the average Time to Close, which can be filtered to a specific Application ID.Time To Close = AVERAGE(Applications[DateDiffCol])
Below image to show an example:Hope this addresses your problem!
johncolley
Solution Sage
Solution SageHi TylerSimpson ,
Based on the information you provided I joined the Application and Funding tables on 'Application ID'
Then created the following column in application table (you can reverse it if you prefer it in the Funding table)
DateDiffCol = DATEDIFF(Applications[Application Date], RELATED(Funding[Funding Date]), DAY)
Then the following measure for the average Time to Close, which can be filtered to a specific Application ID.
Time To Close = AVERAGE(Applications[DateDiffCol])
Below image to show an example:
Hope this addresses your problem!