Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All
Thank you for your help in advance first.
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
HB | Origin |
4411255 | MAD |
556677 | MAD |
337788 | LHR |
667788 | WAW |
Thank you!
Solved! Go to Solution.
@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))
@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))
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 |
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!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
213 | |
81 | |
64 | |
60 | |
56 |