Forum Discussion

CaitlinMc's avatar
CaitlinMc
Frequent Visitor
2 years ago

How to determine Last Status

Good afternoon!   I am trying to create an accountability report that shows the Department that owns the last Action Status for each Job Number.  Our table (WORK_MGT_REQUIREMENTS) has over 300 Act...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi CaitlinMc,

You can create a measure formula to compare records and return flag. Then you can create table visual and use this measure formula on ‘visual level filter’ to filter records:

flag =
VAR currDate =
    MAX ( Table1[Action Date] )
VAR _lastdate =
    CALCULATE (
        MAX ( Table1[Action Date] ),
        ALLSELECTED ( Table1 ),
        VALUES ( Table1[Job Number] ),
        VALUES ( Table1[Department] )
    )
RETURN
    IF ( currDate = _lastdate, "Y", "N" )

Regards,

Xiaoxin Sheng