Calculate working day difference for anything that is early

[kasiaw29]

Hi community,

I have a lovely calculated column which works out a difference of working days between dates. 

LC Wdays = CALCULATE(

COUNTROWS(DimDate),

DATESBETWEEN(DimDate[Date],'Activity History'[Latest Customer Agreed Dispatch Date],RELATED('Sub Project w Activities'[Actual Start]) -1),

DimDate[workday]=1,

ALL(DimDate))

DimDate is my date dimension table. It's working really well for anything that I'd consider late but not for anything that is early. Can anyone share what else I should add? 

 

[amitchandak]

@kasiaw29 , refer 2nd page of this file for working day diff, if this can help

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

try

https://www.dropbox.com/s/o2v5ekfiw5057do/Working%20date%20between%20Dates.pbix?dl=0

[Greg_Deckler]

@kasiaw29 Can you share sample data from your fact table. Example/simulated data is fine.

[kasiaw29]

@Greg_Deckler @amitchandak 

It's a very simple dimdate table. 3 columns= date, weekday number and working day checker.

Week Day = WEEKDAY(DimDate[Date].[Date],2)

Working Day = IF(DimDate[Week Day] in {1,2,3,4,5},1,0)

Thanks