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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Condall
Frequent Visitor

HELP - DAX Calculation for Annual Salaries Using Bi Weekly Amounts

Help! I am very new to Power BI. I’ve been tasked with creating an HR Dashboard for my company that includes salary information. The system we are getting our data from does not provide annual salary information, only bi-weekly amounts. Both hourly and salaried employees are in one report (see below), so I am not sure how to write a DAX calculation to get the annual salary vs "bi-weekly amount" for everyone.

 

The nonexempt employees bi-weekly amount needs to be multiplied by 2080 and include a non-standard shift differential, if applicable.

 

The exempt employees bi-weekly amounts need to be multiplied by 26.

 

How would you write the DAX formula to calculate the annual salaries using different multiplied amounts?

 

Any help will be greatly appreciated. 

 

Emp ID

Formal Name

 Current Hire Date

FLSA Status

Pay Component

Pay Grade

Bi Weekly Amount

1200

Jovany Schneider

5/22/2023

Exempt

0010-Salary

5 PROF01

$32,069.24

1204

Zion Langosh

8/4/2008

Exempt

0010-Salary

9 PROF01

$3,0009.96

1205

Vivienne Daugherty

1/5/2015

Nonexempt

0019-Hourly Rate

10 PROF-HRL01

$204.10

1206

Brielle Mohr

5/1/2003

Nonexempt

0019-Hourly Rate

11 PROF-HRL01

$110.13

1207

Prince Ziemann

5/29/2012

Exempt

0010-Salary

12 PROF01

$35,639.57

1211

Gladys Mayer

12/1/2014

Exempt

0010-Salary

16 PROF01

$32,238.46

1212

Yessenia Corwin

4/26/2021

Nonexempt

0019-Hourly Rate

12 PROF-HRL01

$120.00

1213

Garfield Little

4/12/2021

Nonexempt

0019-Hourly Rate

9 PROF-HRL01

$225.50

1213

Garfield Little

4/12/2021

Nonexempt

0377-IT Hrly Shift

9 PROF-HRL01

$52.00

1 ACCEPTED SOLUTION
Dangar332
Super User
Super User

you can use switch function

try to make a new column

result = 
 switch(true(),
     'tablename'[FLSA status column]="Exempt", 'tablename'[BI Weekly Amount]*26,
      'tablename'[FLSA status column]="NonExempt", 'tablename'[BI Weekly Amount]*2080
  )

 

View solution in original post

3 REPLIES 3
Dangar332
Super User
Super User

you can use switch function

try to make a new column

result = 
 switch(true(),
     'tablename'[FLSA status column]="Exempt", 'tablename'[BI Weekly Amount]*26,
      'tablename'[FLSA status column]="NonExempt", 'tablename'[BI Weekly Amount]*2080
  )

 

Rupak_bi
Resolver II
Resolver II

Use if else function 

Thanks for responding. How would you write the DAX formula to calculate the annual salaries?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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