Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
2 years ago

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...
Need Help
Show and Tell
bdehning's avatar
bdehning
Post Prodigy
2 years ago

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)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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