Need Help -

[CJ_96601]

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	3/20/2021
6	5/20/2021
7	2/20/2021
8	11/20/2021
9	3/20/2021
10	5/20/2021

TABLE 2
Employee	Performance	Performance Year
2	Good	2020
3	VG	2019
3	NI	2020
5	EE	2020
6	Good	2020
6	VG	2019

Requirements:

Plot a bell curve or simple line graph showing the performance of those who left in 2021 (ref Table 1), where performance data is on table 2.  

if performance for 2021 is not available then get the latest from the list (ref Table 2)

Year is base on selection (dynamic)

I appreciate your help.

Thanks

[amitchandak · Accepted solution]

@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]

thanks.

shall i use "add column , custom column" ?