Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper IV
Helper IV

Working Days on Aging Calculation


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?




Delivery Days Working =
    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' ))
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).


Super User
Super User

@bcobrien1977 , You can use networkdays


measure =

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



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


Power BI - Business day with and without using DAX Function NETWORKDAYS:

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors