Forum Discussion
FILTER
I am trying to set up a measure doing the following.
I want to calculate each employee's Hours Worked.
Hours Worked = (8 times the number of business days in the month) - (number of hours taken for PTO).
I have a table that shows the number of business days in each month and another table that shows the number of hours taken for PTO per employee per month.
Is there any way to do this with a general table for the whole year (where I can use a slicer or a filter and look at each month inidividually), or do I have to do individual tables for each month?
2 Replies
i820017 , How you are getting business days stored, One way both these can be joined with a common date table and PTO can be joined with the employee then you can create a meausre as one table join only with date table, so when you use month from date able, then it should give same number business days for the month
I calculated the business days stored by manually looking at each month.
Both tables are connected to a common date table as seen below. I am not able to connect to employee between the 2 highlighted tables.
