Forum Discussion
Working Days between two periods
Yes, like I mentioned - you have to add your workday-filter.
It should work like you did before.
As I had to build the sample data from scratch, I've allowed myself to skip that additional column.
Thank you Imke!! Here is the final formula for anyone else that may need this. Again, this counts the number of workdays between one period and the next (in this...between Due Dates and Ship Dates). And also accounts for if the ship date comes earlier than the due date.
WDC =If( 'Flu Shipped'[Due Date] < 'Flu Shipped'[Date Shipped],CALCULATE(COUNTROWS( DateTable ),DATESBETWEEN ( DateTable[Date], 'Flu Shipped'[Due Date], 'Flu Shipped'[Date Shipped]),DateTable[DateIsWorkingDay]= True,ALL ( 'Flu Shipped' )),CALCULATE(COUNTROWS( DateTable ),DATESBETWEEN ( DateTable[Date], 'Flu Shipped'[Date Shipped], 'Flu Shipped'[Due Date]), DateTable[DateIsWorkingDay]=True,ALL ( 'Flu Shipped' )) * -1)
Community ChampionYes, like I mentioned - you have to add your workday-filter.
It should work like you did before.
As I had to build the sample data from scratch, I've allowed myself to skip that additional column.
Thank you Imke!! Here is the final formula for anyone else that may need this. Again, this counts the number of workdays between one period and the next (in this...between Due Dates and Ship Dates). And also accounts for if the ship date comes earlier than the due date.