Last Max Value of Related Column

[jakeryan56]

Hi all.  Just having a mind blank here but I have two related tables - Cases and Cases_Tasks.

I've illustrated a simplified version of this below but for each case, I need to know the latest task_name.

Any ideas?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

Lastest task name measure: =
VAR latestdate =
    MAX ( Cases_Tasks[date_started] )
VAR filtertable =
    FILTER ( Cases_Tasks, Cases_Tasks[date_started] = latestdate )
RETURN
    IF (
        HASONEVALUE ( 'Cases'[case_id] ),
        MAXX ( filtertable, Cases_Tasks[task_name] )
    )

[amitchandak]

@jakeryan56 , new column in case table

new column =
var _case = maxx(filter(Cases_Tasks, Cases_Tasks[ID] = Cases[ID]) , Cases_Tasks[date_started])
return
maxx(filter(Cases_Tasks, Cases_Tasks[ID] = Cases[ID] && Cases_Tasks[date_started] = _max) , Cases_Tasks[Task_name])