Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bcobrien1977
Helper IV
Helper IV

Working Days on Aging Calculation

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?

 

bcobrien1977_0-1691068602153.png

 

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' ))
2 REPLIES 2
bcobrien1977
Helper IV
Helper IV

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
Super User
Super User

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.