Dax formula - Select value - all except

Hi Anonymous ,

Column =
VAR _o = [den]
VAR _nns_aff_index =
    MAXX (
        TOPN (
            1,
            FILTER ( 'Table', [kpi] = "NNS" ),
            ABS ( [Index] - EARLIER ( 'Table'[Index] ) ), ASC
        ),
        [Index]
    )
VAR _value =
    CALCULATE (
        MAX ( 'Table'[num-calc] ),
        FILTER ( 'Table', [Index] = _nns_aff_index )
    )
RETURN
    IF ( [kpi] = "nns aff", _value, _o )

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.