Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Datachef
Regular Visitor

Help with calculating voluntary turnover

‎04-27-2023 06:31 PM

Hi there, 

 

I have all 2022 staff turnover data isolated in one excel document. Our Voluntary turnover rate needs to consider 3 conditions: was the employee permanent? was the employee full-time? did the employee leave voluntarily? Each of these pieces of information are in separate columns in my data. I just need to add all employees who were terminated if they meet these 3 conditions. What dax formula should I use?

Message 1 of 12
1,172 Views
0
11 REPLIES 11
Ajendra
Resolver I
Resolver I

‎05-03-2023 12:21 PM

333333.JPG

Check this one...Thanks!!

Message 5 of 12
1,035 Views
0
Datachef
Regular Visitor
In response to Ajendra

‎05-05-2023 01:06 PM

Thanks for your help!! Power BI isn't recognizing the term FactTable 

Message 6 of 12
926 Views
0
eliasayyy
Memorable Member
Memorable Member
In response to Datachef

‎05-05-2023 11:34 PM

Usually fact table refers to your own table fact table could be like fkr examlle your 'turnovertable' or 'salestable'

 

When you see fact table this what it means while if someone uses dimtable

 

It usually means like a calendar table or your seperate product table usually it has 1 id only

 

Dim tables are used for better relationship building so you can use dim table like a calendar table to form a relationship with multiple fact tables like example sales table and quantitity table and cost table...

 

So in your case, switch facttable with the name of your table

Message 7 of 12
912 Views
0
Datachef
Regular Visitor
In response to eliasayyy

‎05-06-2023 08:10 AM

I feel like we are getting close but this VAR fields are coming up with errors. See screenshot belwo.

Datachef_0-1683385732025.png

 

Message 9 of 12
893 Views
0
eliasayyy
Memorable Member
Memorable Member
In response to Datachef

‎05-06-2023 08:33 AM

In your formula where result is,

Instead of

Var result = Calculate(SUM('SAP-turnover-final[personnel no.])

 

You need to do

 

Var result = Calculate(SUM('SAP-turnover-final[personnel no.]),-T)

 

RETURN

result

 

You forgot to include return result

 

Message 10 of 12
887 Views
0
Datachef
Regular Visitor
In response to eliasayyy

‎05-06-2023 11:36 AM

Okay, yes that got me a bit further!

This message is still coming up 

The Expression Refers to Multiple Columns. Multiple Columns Cannot Be Converted to a Scalar Value.

Datachef_0-1683398172392.png

 

Message 11 of 12
869 Views
0
eliasayyy
Memorable Member
Memorable Member
In response to Datachef

‎05-06-2023 12:24 PM

In your var result your forgot to put a comma after the sum expression so sum('your table'[your column]),_T) not = T its ,_T this is because calculate expression refers to your expression then comma then filters 

Since _T is the filter you made above in the var so the exoression is your sum then the filter is _T

Message 12 of 12
855 Views
0
Datachef
Regular Visitor
In response to eliasayyy

‎05-06-2023 07:50 AM

Ah, okay thanks I'll try that!

 

Message 8 of 12
898 Views
0
Datachef
Regular Visitor

‎05-03-2023 06:30 AM

Sure, here you go

Name of Action TypeP.Subarea TextPersonnel Area TextName of Employee GroupName of EE SubgroupFromEnd DateCompany NameStart DateAgeTypeYOSFlag
TerminationCoB CUPECOB - CUPEPermanentFull-Time09/01/202212/31/9999City of Barrie9/28/198767Retirement35.25833Permanent Full-Time
Retirement with BenefitsCoB NUGCOB - Non-UnionRetiredFull-Time06/01/202212/31/9999City of Barrie6/13/198860Retirement34.55Retired Full-Time
Retirement with BenefitsCoB NUGCOB - Non-UnionRetiredFull-Time05/28/202212/31/9999City of Barrie8/2/198858Retirement34.41389Retired Full-Time
Retirement with BenefitsCoB NUGCOB - Non-UnionRetiredFull-Time06/26/202212/31/9999City of Barrie6/25/199061Retirement32.51667Retired Full-Time
Retirement with BenefitsCoB CUPECOB - CUPERetiredFull-Time02/26/202212/31/9999City of Barrie6/24/202061Retirement2.519444Retired Full-Time
Retirement with BenefitsCoB CUPECOB - CUPERetiredFull-Time01/01/202212/31/9999City of Barrie10/17/199459Retirement28.20556Retired Full-Time
Retirement with BenefitsFF BPFFACOB - BPFFA/Comm OpRetiredFull-Time11/22/202212/31/9999City of Barrie10/28/199659Retirement26.175Retired Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time08/01/202212/31/9999City of Barrie4/21/199760Retirement25.69444Permanent Full-Time
TerminationCoB CUPECOB - CUPECasualFull-Time11/05/202212/31/9999City of Barrie4/12/202157End of Contract1.719444Casual Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time08/01/202212/31/9999City of Barrie1/2/200165Retirement21.99722Permanent Full-Time
TerminationCoB NUGCOB - Non-UnionCasualPart-Time01/01/202212/31/9999City of Barrie9/2/202067End of Contract2.330556Casual Part-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time11/01/202212/31/9999City of Barrie10/17/200247Voluntary20.20556Permanent Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time09/16/202212/31/9999City of Barrie10/25/200465Retirement18.18333Permanent Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time07/23/202212/31/9999City of Barrie12/5/200538Voluntary17.07222Permanent Full-Time
TerminationCoB NUGCOB - Non-UnionCasualFull-Time10/25/202212/31/9999City of Barrie10/19/202253End of Contract0.2Casual Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time08/05/202212/31/9999City of Barrie7/23/200760Retirement15.43889Permanent Full-Time
TerminationCoB NUGCOB - Non-UnionCasualPart-Time01/04/202212/31/9999City of Barrie9/3/202060Voluntary2.327778Casual Part-Time
TerminationCoB NUGCOB - Non-UnionCasualPart-Time09/23/202212/31/9999City of Barrie5/25/201330End of Contract9.6Casual Part-Time
TerminationCoB NUGCOB - Non-UnionCasualPart-Time09/23/202212/31/9999City of Barrie10/11/200730End of Contract15.22222Casual Part-Time
TerminationCoB CUPECOB - CUPECasualFull-Time11/19/202212/31/9999City of Barrie4/12/202167End of Contract1.719444Casual Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time10/01/202212/31/9999City of Barrie8/15/201135Voluntary11.37778Permanent Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time07/01/202212/31/9999City of Barrie12/15/200855Retirement14.04444Permanent Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time04/28/202212/31/9999City of Barrie3/23/200947Voluntary13.77222Permanent Full-Time
TerminationCoB NUGCOB - Non-UnionCasualPart-Time09/23/202212/31/9999City of Barrie9/6/201628End of Contract6.319444Casual Part-Time
Salary ContinuationCoB NUGCOB - Non-UnionPermanentFull-Time11/21/202212/31/9999City of Barrie1/24/201140Involuntary11.93611Permanent Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time06/10/202212/31/9999City of Barrie5/16/201136Voluntary11.625Permanent Full-Time
Retirement with BenefitsFF BPFFACOB - BPFFA/Comm OpRetiredFull-Time06/01/202212/31/9999City of Barrie4/7/202254Retirement0.733333Retired Full-Time
TerminationCoB NUGCOB - Non-UnionCasualPart-Time02/08/202212/31/9999City of Barrie7/27/202044End of Contract2.427778Casual Part-Time
TerminationCoB NUGCOB - Non-UnionCasualPart-Time01/23/202212/31/9999City of Barrie9/12/202027Voluntary2.302778Casual Part-Time
TerminationCoB CUPECOB - CUPECasualFull-Time11/17/202212/31/9999City of Barrie4/12/202162End of Contract1.719444Casual Full-Time
TerminationCoB CUPECOB - CUPEPermanentFull-Time09/01/202212/31/9999City of Barrie11/17/201146Voluntary11.12222Permanent Full-Time
TerminationCoB NUGCOB - Non-UnionCasualPart-Time09/23/202212/31/9999City of Barrie12/13/201627End of Contract6.05Casual Part-Time
TerminationCoB NUGCOB - Non-UnionPermanentFull-Time09/24/202212/31/9999City of Barrie7/3/201241Voluntary10.49444Permanent Full-Time
Message 4 of 12
1,050 Views
0
Ajendra
Resolver I
Resolver I

‎04-28-2023 01:49 PM

Hey,

 

I hope you are doing well!

 

Share some demo data along with the desire output.

 

thanks,

Ajendra

Message 3 of 12
1,106 Views
0
eliasayyy
Memorable Member
Memorable Member

‎04-28-2023 02:03 AM

can you please show some sample data

Message 2 of 12
1,123 Views
0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

View All