Forum Discussion

Helper II

8 years ago

Solved

Using FIRSTNONBLANK unsuccessfully.

I have data in three columns in table 'Results'. The columns are: A: Deal Reference B: Deal Time C: Deal Rate All cells contain numbers, no text. I need to identify the very first De...

Need Help

Zubair_Muhammad

8 years ago

HI wooand

Try this formula

Formula =
VAR FirstNonBlankTradeStartTime =
    CALCULATE ( FIRSTNONBLANK ( ALL ( Results[Trade Start Time] ), TRUE () ) )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( Results[Dealt Rate], 1 ),
        FILTER (
            ALL ( Results ),
            Results[Trade Start Time] = FirstNonBlankTradeStartTime
        )
    )