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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
21 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
45 | |
15 | |
12 |