Get the date that corresponds to the maxium value

[duggy]

Hi,

I have run the following formula to get the maxium value for the given direction:

Direction1 max per EventFromTime =
MAXX(
    KEEPFILTERS(VALUES('_demo_malls totalentrancehourly'[EventFromTime])),
    CALCULATE(median('_demo_malls totalentrancehourly'[Direction1]))
)

However I need to also return the EventFromTime when this maximum happens. Any clue?

[Sean · Accepted solution]

@duggy

How about this?

EventFromTime when maximum happens =
CALCULATE (
    FIRSTNONBLANK ( '_demo_malls totalentrancehourly'[EventFromTime], 1 ),
    FILTER (
        VALUES ( '_demo_malls totalentrancehourly'[EventFromTime] ),
        CALCULATE ( MEDIAN ( '_demo_malls totalentrancehourly'[Direction1] ) )
            = CALCULATE (
                [Direction1 max per EventFromTime],
                VALUES ( '_demo_malls totalentrancehourly'[EventFromTime] )
            )
    )
)

Good Luck!

[duggy]

Rockstar!!! ive been battling with that for hours! Awesome thank you.