Subject: Power BI - Calculating Attrition Rate Issue

[KK_T]

Hi everyone,

I'm working on Power BI with two tables:

1. Employee Details (Table 1)

   • Columns: Employee Code, Date of Joining, Date of Leaving, Client Code

2. Headcount by Client (Table 2)

   • Columns: Client Code, Client Business Type, Headcount, Date [ Date table is start of month date for each month of each year ]

I want to calculate the attrition rate, but a direct relationship creates a many-to-many issue based on "Client Code."

Any suggestions on how to efficiently calculate attrition rate considering employees who left (Table 1) in relation to headcount (Table 2) based on "Client Code"?

Appreciate any help or insights!

Thanks!

[v-yifanw-msft]

Hi @KK_T ,

Can you provide a concrete example and your expected output. This will help us to better understand and solve your problem.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang