cancel
Showing results for 
Search instead for 
Did you mean: 
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])



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

thanks.

 

shall i use "add column , custom column" ?

 

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors