DAX to Show Earliest Flight

[Anonymous]

Hello there, 

My table consists of flight information in a table entitled "Log". I have a DAX measure at the front end to calculate the earliest/first flight that flew called "Earliest Flight" calculated as follows:

Earliest Flight = MIN('Log'[Flight Date])

 I wanted to create a DAX measure that would show what the corresponding Flight Destination was of this Earliest flight date was and I wrote the following but was getting an error:

Earliest Flight Destination = 
VAR earliest_flight = [Earliest Flight]
RETURN
    CALCULATE (
        MIN(('Log'[From]),
        FILTER ( 'Log', 'Log'[Flight Date] = earliest_flight )
    ))

However, i was getting an error: A single value for column 'From' in table 'Log' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Any assistance would be greatly appreciated! Thanks for your efforts in advance

[vicky_ · Accepted solution]

MIN(('Log'[From]),

You've got two open brackets for the min function, so the DAX thinks that your calculate params are being passed to min - hence the error. Other than that, your function looks fine.

[Anonymous]

Thank you @vicky_ that has worked really well for me! I appreciate the help!