Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

lookup value

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    You could use this formula to create a column

    Result column = 
IF("Plan" in CALCULATETABLE(VALUES('Table'[Action]),ALLEXCEPT('Table','Table'[Name employee])),'Table'[Name employee])

    Result:

     

    Best Regards,

    Lin

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    You could use this formula to create a column

    Result column = 
IF("Plan" in CALCULATETABLE(VALUES('Table'[Action]),ALLEXCEPT('Table','Table'[Name employee])),'Table'[Name employee])

    Result:

     

    Best Regards,

    Lin