Forum Discussion
Anonymous
4 years agoNot applicable
DATEDIFF between 2 dates in different tables
Hi this is my very first post and hoping someone can guide me in the right direction. I'm trying to ascertain the DATEDIFF in minutes between 2 dates that are held in different tables. My first ...
- 4 years ago
Anonymous
Please use
Minutes = SUMX ( CROSSJOIN ( SUMMARIZE ( 'Link Table', dim_date[Date], dim_date[Year] ), SUMMARIZE ( 'Link Table', 'Link Table'[dim_professional_carer_key], 'Link Table'[dim_service_points_key] ) ), CALCULATE ( DATEDIFF ( SELECTEDVALUE ( 'fact_service_point_sessions'[START_DTTM] ), SELECTEDVALUE ( 'fact day therapy theatre events'[Earliest Date] ), MINUTE ), 'fact day therapy theatre events'[First Patient] = "First" ) )
tamerj1
Community Champion
4 years agoHi Anonymous
Can you please share a sample of the expected results?