Forum Discussion

jcardea's avatar
jcardea
Regular Visitor
8 years ago
Solved

Network days with decimals

Hello,   I'm new to power BI, and im trying to create a new calculated column that can calculate the number of working days with decimals between two dates. In excel would be something like this: ...
  • ChandeepChhabra's avatar
    ChandeepChhabra
    8 years ago

    jcardea Hello

     

    Please try the following calculated column

     

    =COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(datestable[Enter],datestable[Modified]),"Day",WEEKDAY ([Date],1)),[Day]<>1&& [Day]<>7))+INT(datestable[Enter])+1-datestable[Enter]+datestable[Modified]-INT(datestable[Modified])-2

     

    Please replace

    1. datestable by the name of your own table
    2. Enter column by start date
    3. Modified column by end date

    The formula considers Sat and Sun as weekends

     

ChandeepChhabra's avatar
ChandeepChhabra
Icon for Impactful Individual rankImpactful Individual
8 years ago

jcardea Hello

 

Please try the following calculated column

 

=COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(datestable[Enter],datestable[Modified]),"Day",WEEKDAY ([Date],1)),[Day]<>1&& [Day]<>7))+INT(datestable[Enter])+1-datestable[Enter]+datestable[Modified]-INT(datestable[Modified])-2

 

Please replace

  1. datestable by the name of your own table
  2. Enter column by start date
  3. Modified column by end date

The formula considers Sat and Sun as weekends

 

jcardea's avatar
jcardea
Regular Visitor
8 years ago

Hi,

 

I trieded but there was an error saying "The start date in Calendar function can not be later than the end date." and I'm sure that none of the starting dates are later than the end dates...

 

thanks!

  • ChandeepChhabra's avatar
    ChandeepChhabra
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

    jcardea Can you please share your data ? I'll see what's going wrong