topic Re: Last Max Value of Related Column in DAX Commands and Tips

Last Max Value of Related Column

jakeryan56 — Wed, 30 Mar 2022 03:18:06 GMT

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?

Re: Last Max Value of Related Column

amitchandak — Wed, 30 Mar 2022 03:44:00 GMT

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])

Re: Last Max Value of Related Column

Jihwan_Kim — Wed, 30 Mar 2022 03:51:17 GMT

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] ) )