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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.