Working Days on Aging Calculation

[bcobrien1977]

Hi,

I am trying to get a net working days for an aging calculation where you have a a filter date (report date).  The calculation works fine when I just do the days but when I add in the business days, I get this weird error.

Basically I want at 8/1, to get an accurate calculation for working days and total days for each order created.  

I have a Many to one relationship between createddate and the filter date.

Can anyone point me in the right direction?

Thanks

Brendan

Delivery Days Working =

CALCULATE(

    COUNTROWS ( 'Filter Dates' ),

DATESBETWEEN ( 'Filter Dates'[Date],  'Detail INC Aging'[Daterun], 'Detail INC Aging'[CreatedDate] - 1),

    'Filter Dates'[Business Day?]=1,

    ALL ( 'Detail INC Aging' ))

[bcobrien1977]

Thanks that is really helpful. What I struggle with is that the start date could be dynamic.  Someone could want to run it for 7/1 instead of 8/1 so how would I get that end date to change from 7/1 to 8/1 (while keeping the old date).

Thanks

[amitchandak]

@bcobrien1977 , You can use networkdays

measure =

calculate(networkdays(min(Table[Stare]), max(Table[End Date]), 1)

Column=

calculate(networkdays((Table[Stare]), (Table[End Date]), 1)

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c