HELP - DAX Calculation for Annual Salaries Using Bi Weekly Amounts

[Anonymous]

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

[Dangar332 · Accepted solution]

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]

Use if else function 

[Anonymous]

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