Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have data as below (columns are: Flight date, Carrier, Flight number, fare code, fare amount):
I want to get the lowest fare amount by each flight date and carrier, regardless flight number, and the fare code relating to that fare amount.
I have tried creating DAX BaseAmt = min([amt])
But I want it to only show lowest value and its Fare code.
(For above table, it should show only 1 row per carrier, for VN0V it should be GAP4VNWS 259,000)
Many thanks
Solved! Go to Solution.
Hi @anhngv ,
Maybe you can try to create two measures to do that.
MEASURE firstfcc =
VAR _1 = TOPN ( 1, 'Table', [BaseAmt], ASC )
RETURN MAXX ( _1, [first fcc] )
Measurebaseamt =
VAR _1 = TOPN ( 1, 'Table', [BaseAmt], ASC )
RETURN MAXX ( _1, [BaseAmt] )
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @anhngv ,
Maybe you can try to create two measures to do that.
MEASURE firstfcc =
VAR _1 = TOPN ( 1, 'Table', [BaseAmt], ASC )
RETURN MAXX ( _1, [first fcc] )
Measurebaseamt =
VAR _1 = TOPN ( 1, 'Table', [BaseAmt], ASC )
RETURN MAXX ( _1, [BaseAmt] )
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Amazing! Thank you for your help.
Actually I just need MEASURE firstfcc. Measurebaseamt is exactly [BaseAmt] itself.
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |