Forum Discussion

Helper V

4 years ago

Solved

Need Help -

I've got 2 tables: Table 1 - Attrition Table Table 2 - Performance Table TABLE 1 2021 Emp Termination Date 1 3/20/2021 2 5/20/2021 3 2/20/2019 4 11/20/2021 5 ...

Need Help

amitchandak
4 years ago
CJ_96601 , one of the ways is to copy the performance of termination in the year in first table

performance = maxx(filter(Table2, Table2[employee] = Table1[Emp] && year(Table1[termination date]) = Table2[Performance Year] ) , Table2[Performance])

amitchandak

Super User

4 years ago

CJ_96601 , one of the ways is to copy the performance of termination in the year in first table

performance = maxx(filter(Table2, Table2[employee] = Table1[Emp] && year(Table1[termination date]) = Table2[Performance Year] ) , Table2[Performance])

CJ_96601

Helper V

4 years ago

thanks.

shall i use "add column , custom column" ?