Lookup DateTime based on the MAX of another column

[vpatel55]

I would like a DAX formula that would return the DateTime corresponding to the MAX of Price on this list.

27 is the largest Price, so the answer should be either 17/12/2020 17:00 or 18/12/2020 18:00, I don't mind which one:

Here is the formula that I am currently using:

DateTime of most expensive product =
CALCULATE (
    FIRSTNONBLANK ( Data[DateTime], 1 ),
    FILTER ( Data, MAX ( Data[Price] ) )
)

The result appearing is 10:00. This is not the required result. I can see what its doing, its returning the first row that is not blank. But I don't know which other "wrapper" I can use? I tried using LOOKUPVALUE, but as I have a duplicate this does not work.

Any help would be appreciated. Here is the sample file:

https://www.dropbox.com/s/a5001h3htve47lf/Sample%20file.pbix?dl=0

[ChrisMendoza · Accepted solution]

@vpatel55 - try the following:

Measure = 
VAR __maxPrice = CALCULATE(MAX('Table'[Price]),ALL('Table'))
RETURN 
    CALCULATE(
        MAX('Table'[DateTime]),
        'Table'[Price] = __maxPrice
    )

[vpatel55]

Huge Kudos @ChrisMendoza , super user indeed!