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'm using this to identify the first value in a selection filtered by a slicer.
Arrival Price =
IF (
ISFILTERED ( Sheet1[Deal Reference Id] ) && HASONEVALUE ( Sheet1[Deal Reference Id] ),
FIRSTNONBLANK(Sheet1[Dealt Rate], 0 )
)
But it is returning the LOWEST value, not the first value. What am I doing wrong please?
Solved! Go to Solution.
Hi @wooand
FirstNonBlank is like using a MIN function and will return the lowest value rather than the first item in a sequence.
In fact this is possible. The excellent Zubair Mohammed provided the following:
Arrival Price =
VAR FirstNonBlankTradeStartTime =
CALCULATE ( FIRSTNONBLANK ( VALUES ( Algo[Trade Start Time] ), TRUE () ) )
RETURN
CALCULATE (
FIRSTNONBLANK ( Algo[Dealt Rate], 1 ),
FILTER ( Algo, Algo[Trade Start Time] = FirstNonBlankTradeStartTime )
)
Which works well.
In fact this is possible. The excellent Zubair Mohammed provided the following:
Arrival Price =
VAR FirstNonBlankTradeStartTime =
CALCULATE ( FIRSTNONBLANK ( VALUES ( Algo[Trade Start Time] ), TRUE () ) )
RETURN
CALCULATE (
FIRSTNONBLANK ( Algo[Dealt Rate], 1 ),
FILTER ( Algo, Algo[Trade Start Time] = FirstNonBlankTradeStartTime )
)
Which works well.
Hi @wooand
FirstNonBlank is like using a MIN function and will return the lowest value rather than the first item in a sequence.
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |