Forum Discussion

CTW's avatar
CTW
Regular Visitor
8 years ago
Solved

Creating a Calculated from a other columns

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         ...
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi CTW,

     

    Same to your DAX formula, try following calculated column:

     

    First Test Result =
CALCULATE (
    MAX ( data[Result] ),
    FILTER (
        data,
        data[TestTimeTest] = data[TestTimeFr]
            && 'Data'[S/N] = EARLIER ( 'Data'[S/N] )
            && data[station] = EARLIER ( 'Data'[station] )
    )
)

     

    Thanks,
    Xi Jin.

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi CTW,

 

Same to your DAX formula, try following calculated column:

 

First Test Result =
CALCULATE (
    MAX ( data[Result] ),
    FILTER (
        data,
        data[TestTimeTest] = data[TestTimeFr]
            && 'Data'[S/N] = EARLIER ( 'Data'[S/N] )
            && data[station] = EARLIER ( 'Data'[station] )
    )
)

 

Thanks,
Xi Jin.