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
        )
    )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Jihwan, the measure works fine as expected, thanks!

but in my actual file, it was having major performance issues (loading data). i believe this is due to the long dax queries in the measure. And i'm kinda lost on how to simplify it. Appreciate your insights on this again, thank you so much.