Forum Discussion

Atseaukes's avatar
Atseaukes
Frequent Visitor
8 years ago
Solved

Return value based on latest date-time and ID

Hi all,   I have the follow example set 'Events Completion': user_id date time subject_title 1416 6-8-2018 09:37:02 Session 1 A 1416 6-8-2018 09:37:00 Session 2 A 208 6-8-201...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    Atseaukes

     

    Try the following steps:

     

    1) Calculate Max Date for each User ID

    = CALCULATE(MAX(date), ALLEXCEPT(TableName,TableName[user_id]))

     

    2) Use If statement to find subject title

    =IF(MAX DATE = DATE,subject_title,NULL)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Atseaukes

 

Try the following steps:

 

1) Calculate Max Date for each User ID

= CALCULATE(MAX(date), ALLEXCEPT(TableName,TableName[user_id]))

 

2) Use If statement to find subject title

=IF(MAX DATE = DATE,subject_title,NULL)