Forum Discussion

CTW's avatar
CTW
Regular Visitor
8 years ago
Solved

to show value in calculated column based on another column (lookup?)

Hi DAX professionals: I've run into a issue where i'm trying to create a calculated column based off of other columns. please refer to the below screen shot to what my issue is:   Station         ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi CTW

     

    Try this column

     

    First Test Result=
CALCULATE (
    FIRSTNONBLANK ( Data[Result], 1 ),
    FILTER (
        ALLEXCEPT ( Data, Data[Station], Data[S/N] ),
        Data[TestTimeTest] = Data[TestTimeFr]
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi CTW

 

Try this column

 

First Test Result=
CALCULATE (
    FIRSTNONBLANK ( Data[Result], 1 ),
    FILTER (
        ALLEXCEPT ( Data, Data[Station], Data[S/N] ),
        Data[TestTimeTest] = Data[TestTimeFr]
    )
)