Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am trying to make a report for time registered on project and project lines.
My problem is that I have different wage types.
In example one wage type is "Monthly paid" and one is "Overtime 50% addition" and one is "Plusstime to timebank"
Monthly paid 7,5 hours
Overtime 50% 2,5 hours (addition to hourly pay)
Plusstime to TB 2,5 hours
Which adds up to 12, 5 hours when they have only worked 10 hours.
Sometimes they work without getting overtime
Monthly paid 7,5 hours
Plusstime to TB 2,5 hours
Which adds up to 10 hours which is correct.
I want to change wage types from the list I have today into this:
Wage Type today | Wage type I need |
Fastlønn | Normal tid |
Plusstid 1 | Normal tid |
Plusstid 2 | Normal tid |
Overtidstillegg 50% | Overtidstillegg 50% |
Overtidstillegg 100% | Overtidstillegg 100% |
Offshore kompensasjon | Offshore |
Offshore tillegg | Offshore |
Helligdagsgodtgj | Helligdagsgodtgj |
Nattillegg | Nattillegg |
Then I need to group New Wage types per project, employee, date and hours
If there is overtime and/or Offshore then that needs to be subtracted from Normal time per date and emplyee.
We also have to consider that new wage types may come later, so they need to be displayed in the report as well.
This is the date I have on one project ( I use Prosjekt.1 and Prosjektlinje to group in report)
Prosjekt.1 | Prosjekt.2 | Prosjektlinje | Dato | Ansatt (Employee) | Lønnsart (wage type) | Totalt antall timer |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 24.10.2020 | 2000 | 900 Plusstid 1 | 13 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 24.10.2020 | 2000 | 17 Overtidstillegg 50% | 5 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 24.10.2020 | 2008 | 900 Plusstid 1 | 5 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 24.10.2020 | 2008 | 17 Overtidstillegg 50% | 5 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 24.10.2020 | 2008 | 901 Plusstid 2 | 8 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 24.10.2020 | 2008 | 18 Overtidstillegg 100% | 8 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 24.10.2020 | 2000 | 18 Overtidstillegg 100% | 8 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 25.10.2020 | 2000 | 900 Plusstid 1 | 14 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 25.10.2020 | 2000 | 18 Overtidstillegg 100% | 14 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 25.10.2020 | 2008 | 901 Plusstid 2 | 12 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 25.10.2020 | 2008 | 18 Overtidstillegg 100% | 12 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 26.10.2020 | 2000 | 1 Fastlønn | 1,97 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 26.10.2020 | 2000 | 901 Plusstid 2 | 0,35 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 26.10.2020 | 2006 | 1 Fastlønn | 4,75 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 26.10.2020 | 2003 | 1 Fastlønn | 2,57 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 26.10.2020 | 2003 | 900 Plusstid 1 | 0,13 |
10356 | kontroll av Black Eagel | 130 Timeforbruk | 26.10.2020 | 2006 | 900 Plusstid 1 | 0,03 |
You can create groups in Power BI (on the UI side) that can map your wage types accordingly. You can then base measures or calculated columns on these groups.
Where they don't help is when you have new wage types coming in. Groups have a bucket "Others" which you would have to manually monitor for new items, and then adjust your groups and formulas accordingly.