Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Getting two latest value two different column in different table

Hi all, I have some difficulties and i need some help.    My task is to get the latest application date and also the latest status from that application date without using the power query, only the...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Thank you for your message.

    I created a measure for application date as well.

    Please check the attached file, and please check if it suits your requirement.

    Thank you.

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

Status expected measure: =
VAR _latestdate =
    MAX ( Student[Application Date] )
VAR _maxstatuskey =
    MAXX (
        FILTER ( Student, Student[Application Date] = _latestdate ),
        Student[Application Status Key]
    )
RETURN
    IF (
        HASONEVALUE ( Student[Student ID] ),
        CALCULATETABLE (
            VALUES ( 'Status'[Status] ),
            'Status'[Application Status Key] = _maxstatuskey
        )
    )