Forum Discussion

Dudeman's avatar
Dudeman
Icon for Helper I rankHelper I
5 years ago
Solved

Finding MIN date in a table within a group

Hi. I have the following flight booking data. I'm looking for a Dax formula to pick out the actual destination. See below for what I'm looking for and some IF logic. RDU is the actual destination, th...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Dudeman 
    There are only a few more rows I can just type in. That was my mistake, I have thought about the multiple booking numbers, but forgot to bring it into the formula. Change the Result Destination measure to the following should work.

     

    Result Destination = IF([MaxArrival]=MINX(FILTER(ALLSELECTED(Legs),[BookingNumber]=MAX([BookingNumber])),[MaxArrival]) && [ArriveConnect]="Arrival",MAX([arrivalAirport]))
     

     

    Best Regards
    Paul Zheng _ Community Support Team

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dudeman 
There are only a few more rows I can just type in. That was my mistake, I have thought about the multiple booking numbers, but forgot to bring it into the formula. Change the Result Destination measure to the following should work.

 

Result Destination = IF([MaxArrival]=MINX(FILTER(ALLSELECTED(Legs),[BookingNumber]=MAX([BookingNumber])),[MaxArrival]) && [ArriveConnect]="Arrival",MAX([arrivalAirport]))
 

 

Best Regards
Paul Zheng _ Community Support Team

 

  • Dudeman's avatar
    Dudeman
    Icon for Helper I rankHelper I
    5 years ago

    Amazing. Thank you SO much Anonymous Paul. Really appreciate your help on this.

     

    If it's not too much to ask, and no rush at all, would you mind explaining what the formula is doing? It's a bit difficult for me to understand all the pieces and how they're working together here.

     

    Thanks again.

  • Dudeman's avatar
    Dudeman
    Icon for Helper I rankHelper I
    5 years ago

    Sorry Paul. One last question. That measure works, but I now need to composite in a country table with a relationship to the airport code. Result Destination needs to be in a calculated column in order for me to link the detination airport code to my country table (I think?).

     

    Can you help with what the calculated column formula would be for the solution you provided?

     

    Thanks again.