Forum Discussion
Laur1987
4 years agoFrequent Visitor
Get chart using DAX
I need to get a chart like from Excel. I need to count the minutes between "Leave Time" and "Join Time" but considering that "Join time in the 14:05 rowcontain count from 14:04, so "14:11" row contai...
- 4 years ago
Hi Laur1987
Thank you for the clarifications. Please refer to the sample file with the solution
Count = VAR CurrentJoinTime = MAX ( '81099122685_-_Attendee_Report'[Join Time] ) RETURN CALCULATE ( SUMX ( '81099122685_-_Attendee_Report', VAR JoinTime = '81099122685_-_Attendee_Report'[Join Time] VAR LeaveTime = '81099122685_-_Attendee_Report'[Leave Time] RETURN IF ( CurrentJoinTime >= JoinTime && CurrentJoinTime <= LeaveTime, 1, 0 ) ), REMOVEFILTERS( '81099122685_-_Attendee_Report' ), '81099122685_-_Attendee_Report'[Join Time] <= CurrentJoinTime )