Return a value from another column based on conditions set by other columns

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

 

It is for creating Calculated Column, not Calculated Measure.

 

 

WINDOW function (DAX) - DAX | Microsoft Learn

 

Near Low Temp Timing CC =
VAR _condition =
    ADDCOLUMNS (
        Data,
        "@condition", IF ( Data[High Temp Start] = "HT Start", 1, 0 )
    )
VAR _group =
    ADDCOLUMNS (
        _condition,
        "@group",
            SUMX (
                WINDOW (
                    1,
                    ABS,
                    0,
                    REL,
                    _condition,
                    ORDERBY ( Data[Test Time], ASC, Data[Index], ASC ),
                    ,
                    PARTITIONBY ( Data[Eval ID] ),
                    MATCHBY ( Data[Index], Data[Eval ID], Data[Test Time] )
                ),
                [@condition]
            )
    )
VAR _result =
    ADDCOLUMNS (
        _group,
        "@result",
            MINX (
                FILTER (
                    _group,
                    Data[Eval ID] = EARLIER ( Data[Eval ID] )
                        && [@group] = EARLIER ( [@group] )
                ),
                Data[Test Time]
            )
    )
RETURN
    MINX (
        FILTER (
            _result,
            Data[Eval ID] = EARLIER ( Data[Eval ID] )
                && Data[Test Time] = EARLIER ( Data[Test Time] )
                && Data[High Temp Start] = EARLIER ( Data[High Temp Start] )
        ),
        [@result]
    )