Forum Discussion
ctedesco3307
Resolver II
Resolver IIFilter Non Working Days in a Date Range
Greetings Alll; I have a working measure that calculates the number of (working) hours between 2 date ranges but I need to filter out the non working days in the calculation The date range is ...
ok- actually solved my own problem and made a new column for the Plan Hours measure to reference - but if any one has a more sophisticated solution - please share - learning as I go here. Thx
I replaced the TDate[Date] column references in Plan Hours with TDate[WorkingDay] - new column calc I added in my TDates table
WorkingDay = IF(OR(TDate[WeekDay]=1,TDate[WeekDay]=7),date(1900,1,1),IF(ISBLANK(TDate[THoliday]),TDate[Date],date(1900,1,1)))
ctedesco3307Resolver II
Resolver IIok- actually solved my own problem and made a new column for the Plan Hours measure to reference - but if any one has a more sophisticated solution - please share - learning as I go here. Thx
I replaced the TDate[Date] column references in Plan Hours with TDate[WorkingDay] - new column calc I added in my TDates table
WorkingDay = IF(OR(TDate[WeekDay]=1,TDate[WeekDay]=7),date(1900,1,1),IF(ISBLANK(TDate[THoliday]),TDate[Date],date(1900,1,1)))