cancel
Showing results for
Did you mean:
Helper II

## Dax - Compare two or more row of data, and show the MIN one

Hi All

I have below Table.

HB is not an unquie number

Master is unquie number

I want to show the row of data with earliest COB

i am not sure how can i do that, not sure if anyone could help me?

Raw Data:

 HB Master COB Origin 4411255 ABC12345 12-Aug MAD 4411255 CDE54321 15-Aug HKG 556677 ABD12345 12-Aug MAD 337788 UIZ56789 11-Aug LHR 667788 KIL12345 11-Aug WAW 667788 POI55667 12-Aug FRA 667788 UYE99778 13-Aug CDG

Ideal Result

Thank you!

1 ACCEPTED SOLUTION
Super User

@Ericwhv , I have blog for latest value, You can try the same with min for min value

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

Last Status = var _max = minx(filter(ALLSELECTED(Data), Data[HB] = Max(Data[HB])), Data[COD])
return
CALCULATE(max(Data[Origin]), filter((Data) ,  Data[Date] =_max))
3 REPLIES 3
Super User

@Ericwhv , I have blog for latest value, You can try the same with min for min value

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

Last Status = var _max = minx(filter(ALLSELECTED(Data), Data[HB] = Max(Data[HB])), Data[COD])
return
CALCULATE(max(Data[Origin]), filter((Data) ,  Data[Date] =_max))
Helper II

Hi Amit

sorry for asking again, if i would like to add one more criteria, is it possible?

shall we check if leg check column has a "Last leg" or not?
if there is a "Last Leg", then show that HB
if there are empty or no "Last Leg" exist, then keep the same logic before.

thank you.

Raw Data:

 HB Master COB Origin Leg Check 4411255 ABC12345 MAD Last Leg 4411255 CDE54321 15-Aug HKG First Leg 556677 ABD12345 12-Aug MAD 337788 UIZ56789 11-Aug LHR 667788 KIL12345 11-Aug WAW Last Leg 667788 POI55667 12-Aug FRA 667788 UYE99778 13-Aug CDG

Ideal Result

 HB Origin 4411255 MAD Last Leg 556677 MAD 337788 LHR 667788 WAW
Helper II

Thank you Amit!
you help me again!
it is work and the porblem sorted.

but could you mind to go through with me why that is work?
I want to know how to fishing instead of keep asking fish from you lol

Thank you so much!!

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors