Forum Discussion

Helper V

2 years ago

Solved

Calculate date difference between different meeting types which are stored in the same column

Hello I am trying to create a table to calculate the difference between different meeting dates per user (i,e days between intro and assess or intro and support, this must be on the first attended m...

Need Help

ryan_mayu
2 years ago
Elisa112

if you want to get the first attended meeting, try to change maxx to minx
Elisa112
2 years ago
ryan_mayu I have successfully added the attended meetings, there was a missing bracket and common which was causing the error.
Thank you and I can now mark your solution as the accepted (and correct) solution

ryan_mayu

Super User

2 years ago

Elisa112

modify the DAX, pls try this

Table 2 = ADDCOLUMNS( ADDCOLUMNS(SUMMARIZE('Table','Table'[UserID ]),"introdate",maxx(FILTER('Table','Table'[UserID ]=EARLIER([UserID ] )&& 'Table'[MeetingType]="Intro"),'Table'[Meetingdate]),"assessdate",maxx(FILTER('Table','Table'[UserID ]=earlier([UserID ] )&& 'Table'[MeetingType]="Assess"),'Table'[Meetingdate])),"datedif",DATEDIFF([introdate],[assessdate],day))