Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Networkdays issue with filtering holidays

I have an issue: Approach of calculation network days does not work. I Prepared everything by instruction which is presented here (https://www.youtube.com/watch?v=9M1V_m-oEzc) Link on pbix. https:/...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi Anonymous,

     

    We can take the following steps to meet your requirement.

     

    1. Update one of your formulas 

    From

    WorkingDays = IF(OR('Date'[Date]=6, 'Date'[Date]=7),0, 1)

    To

    WorkingDays = IF(OR('Date'[WeekDay]=6,'Date'[WeekDay]=7),0,1)


    2. Create a new column.

    workday = IF('Date'[WorkingDays]=1,DAY('Date'[Date]),BLANK())


    3. Then we can get the result we need.

     

     

    For more details, please check the pbix as attached.

    https://www.dropbox.com/s/3b68yfqbdz3vo9n/NetWorkDays2.1.pbix?dl=0

     

    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

We can take the following steps to meet your requirement.

 

1. Update one of your formulas 

From

WorkingDays = IF(OR('Date'[Date]=6, 'Date'[Date]=7),0, 1)

To

WorkingDays = IF(OR('Date'[WeekDay]=6,'Date'[WeekDay]=7),0,1)


2. Create a new column.

workday = IF('Date'[WorkingDays]=1,DAY('Date'[Date]),BLANK())


3. Then we can get the result we need.

 

 

For more details, please check the pbix as attached.

https://www.dropbox.com/s/3b68yfqbdz3vo9n/NetWorkDays2.1.pbix?dl=0

 

Regards,
Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

Does that make sense? If so , could you please mark this answer as a solution?

 

Regards,
Frank