Forum Discussion
Networkdays
I tried using the following but it is one day off due to February 29th this year I beleive. I got total days of 106 but it should be 107? WorkingDaysFriSatHolidays = VAR _holidays = {DATE(202...
Greg, How do I incorporate my Date of Service Filter
Date of Service =
VAR dte =
DATE(
INT(isiInspections[DateOfService] / 10000)
, MOD(INT(isiInspections[DateOfService] / 100), 100)
, MOD(isiInspections[DateOfService], 100)
)
RETURN
IF(
dte < TODAY()
, dte
)
So it will control my Card or be a mesure that provides number of working days.
Working Days =
VAR _FirstDate = MIN('VW_DATE_DIM'[Date])
Var _LastDate = MAX('VW_DATE_DIM'[Date])
Var _Holidays =CALCULATETABLE(
DISTINCT('VW_DATE_DIM'[DATE]),
'VW_DATE_DIM'[ISHOLIDAY] = 1)
RETURN
NETWORKDAYS(
_FirstDate,
_LastDate,
1,
_Holidays)
I got close with, but I am off a few days so something is not counting right.
Working Days =
VAR _FirstDate = MIN('isiInspections'[Date of Service])
Var _LastDate = MAX('isiInspections'[Date of Service])
Var _Holidays =CALCULATETABLE(
DISTINCT('isiInspections'[Date of Service]),
'VW_DATE_DIM'[ISHOLIDAY] = 1)
RETURN
NETWORKDAYS(
_FirstDate,
_LastDate,
1,
_Holidays)
Hi,bdehning
Has your problem been solved?
If it is solved, please share your solution, which will allow other community members who have the same problem as you to find a solution faster.
If not, please share the pbix file except for the sensitive data, and then re-describe your needs, such as start and end dates, the days and days of the week you take off as a week, and the days of vacation in between, and what kind of results you expect. We'll be better suited to help you solve your problems.
Best Regards,
Leroy Lu