Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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
)
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
)
Use if else function
Thanks for responding. How would you write the DAX formula to calculate the annual salaries?