Working Days on Aging Calculation

Question

Hi,I am trying to get a net working days for an aging calculation where you have a a filter date (report date).&nbsp; The calculation works fine when I just do the days but when I add in the business days, I get this weird error.&nbsp;Basically I want at 8/1, to get an accurate calculation for working days and total days for each order created.&nbsp;&nbsp;&nbsp;I have a Many to one relationship between createddate and the filter date.&nbsp;Can anyone point me in the right direction?&nbsp;&nbsp;ThanksBrendanDelivery Days Working = CALCULATE(&nbsp; &nbsp; COUNTROWS ( 'Filter Dates' ),DATESBETWEEN ( 'Filter Dates'[Date], &nbsp;'Detail INC Aging'[Daterun], 'Detail INC Aging'[CreatedDate] - 1),&nbsp; &nbsp; 'Filter Dates'[Business Day?]=1,&nbsp; &nbsp; &nbsp; &nbsp; ALL ( 'Detail INC Aging' ))

amitchandak · Answer

Anonymous , You can use networkdays 
&nbsp;
measure =
calculate(networkdays(min(Table[Stare]), max(Table[End Date]), 1)
&nbsp;
Column=
calculate(networkdays((Table[Stare]), (Table[End Date]), 1)
&nbsp;
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_chttps://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c

anonymous · Answer

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

Forum Discussion

Working Days on Aging Calculation

2 Replies

Related content

Age Bins

Calculating quote ages

Calculate Age column

stock ageing

Calculating Age, Age Grouping, and Age as of