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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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

@Anonymous , 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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors
Top Kudoed Authors