Problem Of The Week 3: Timesheet & Wages - DAX Solution

The third Problem of the Week calls for a DAX solution to timesheet and wages problem. Watch how Greg solved this problem.

The Problem of the Week initiative is open to members and non-members with the goal to improve Power BI skills through practical application.

To join, you may send your solution to [email protected]

***** Related Links *****
Enterprise DNA Introduction Video for Problem of the Week #3:
https://www.youtube.com/watch?v=9pqCKgYf6XY

Enterprise DNA Forum Post for Problem of the Week #3:
https://forum.enterprisedna.co/t/problem-of-the-week-3-dax-timesheet-and-wages/13256

Enterprise DNA Forum post for Extended Date Table M Code:
https://forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390

Enterprise DNA Forum post for Fix Incorrect Totals:
https://forum.enterprisedna.co/t/fix-incorrect-totals/8834

***** Video Details *****
2:10 formula for regular hours
3:50 formula for overtime hours
4:07 formula for holiday hours
4:23 formula for regular wages
6:10 solution for measures
8:55 construct virtual table that mimics the physical table
12:00 difference between measures and calculated columns

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/