DAX Measure addition/change help needed

[Auski]

Good afternoon all,

I have the following measure to return the latest task/appointment date, which works brilliantly. 

Appointment (ALL) Most Recent =

VAR appttaskdate =

    CALCULATE (

        MAX ( Task[Created_Date] ),

        FILTER ( Task, Task[Created_Date] < TODAY () ),

        Task[task_record_type] <> "System Generated Task"

    )

VAR apptdate =

    CALCULATE (

        MAX ( Appointments[appointment_date] ),

        FILTER ( Appointments, Appointments[appointment_date] < TODAY () ),

        Appointments[status] = "Completed"

    )

RETURN

    IF ( apptdate > appttaskdate, apptdate, appttaskdate )

Based of this measure, I now also need to return Task[task_record_type]. Any ideas how I might do this? Would a second measure be best, or modify this measure?

https://drive.google.com/file/d/1poBCfP3UPDIl7tDuTjHdfsBuyqT2cEwA/view?usp=sharing

Thanks so much,

[Auski]

@amitchandak Thanks for your time with this. I think you are close, however I neglected to mention there is Task[task_record_type] and also Appointment[Record Type] to consider.

Appointment (ALL) Most Recent =

VAR appttaskdate =

    CALCULATE (

        MAX ( Task[Created_Date] ),

        FILTER ( Task, Task[Created_Date] < TODAY () ),

        Task[task_record_type] <> "System Generated Task"

    )

VAR apptdate =

    CALCULATE (

        MAX ( Appointments[appointment_date] ),

        FILTER ( Appointments, Appointments[appointment_date] < TODAY () ),

        Appointments[status] = "Completed"

    )

RETURN

    IF ( apptdate > appttaskdate, Task[task_record_type], Appointment[Record Type] )

Hope that makes sense. 

I have shared on my google drive.
https://drive.google.com/file/d/1poBCfP3UPDIl7tDuTjHdfsBuyqT2cEwA/view?usp=sharing 

Thanks!!

[Ashish_Mathur]

There's a lot of data there which in turn is causing confusion.  Could you share a smaller dataset and show the expected result.

[Auski]

@Ashish_Mathur Thanks for your reply. I have updated the data set and included expect result as requested. Hope this helps! 

https://drive.google.com/file/d/1poBCfP3UPDIl7tDuTjHdfsBuyqT2cEwA/view?usp=drive_link

[Ashish_Mathur · Accepted solution]

PBI file attached.  Those images are very small so i can barely read anything.

[Auski]

@Ashish_Mathur  Thank you for your time with this Ashish - you're a genius!

[Ashish_Mathur]

You are welcome.  Thank you for your kind words.

[amitchandak]

@Auski , Try like

CALCULATE (
Lastnonblankvalue ( Task[Created_Date], max(Task[task_record_type] )),
FILTER ( Task, Task[Created_Date] < TODAY () ),
Task[task_record_type] <> "System Generated Task"
)