cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors