Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
CJ_96601
Helper V
Helper V

Need Help -

I've got 2 tables:  

 

Table 1 - Attrition Table

Table 2 - Performance Table

 

TABLE 1

2021
EmpTermination Date
13/20/2021
25/20/2021
32/20/2019
411/20/2021
53/20/2021
65/20/2021
72/20/2021
811/20/2021
93/20/2021
10

5/20/2021

 

 

 

TABLE 2  
EmployeePerformancePerformance Year
2Good2020
3VG2019
3NI2020
5EE2020
6Good2020
6VG2019

 

 

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

thanks.

 

shall i use "add column , custom column" ?

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.