Dax expression to display the latest date in the Matrix Visual

[Anonymous]

My Test data

Name   type     Modifieddate   Other Columns
-------------------------------------------------------
A       type1   1/1/2021
A       type2   1/1/2021
B       type3   1/2/2021
B       type1   1/2/2021
C       type1   1/3/2021
A       type1   1/3/2021
A       type3   1/3/2021
B       type2   1/4/2021

My Matrx output expected.

	Type1	Type2	Type3
A	1/3/2021	1/1/2021	1/3/2021
B	1/2/2021	1/4/2021	1/2/2021
C	1/3/2021

Is there a dax measure that would achieve this?

Thanks!

[ERD · Accepted solution]

Hi @Anonymous ,

You can try this measure:

LatestDate =
VAR selectedName = SELECTEDVALUE ( T[Name] )
VAR selectedType = SELECTEDVALUE ( T[type] )
RETURN
    CALCULATE (
        MAX ( T[Modifieddate] ),
        T[Name] = selectedName,
        T[type] = selectedType
    )

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Anonymous]

@ERD 

It's retuning the date data 12/31/2021 12:00:00 AM

[ERD]

[Anonymous]

It Worked!! Thanks @ERD  

The earlier issue is due to my data model which caused the Date field to return inconsistent data. After referring to right columns the Dax you shared had worked.