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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Jays_D
Advocate II
Advocate II

Don't count Networkdays as 1 if same day

Hi All,

 

I have a custom column which calculates Networkdays between 2 dates, and it will only calculate if a start date and end date are present, otherwise it shows as blank. What I cannot seem to get it to do is provide a "0" value if Start Date and End Date are the same day. I have tried to append "-1" at the end of my DAX but that just returns a -1 on values that are blank.

 

This is my DAX:

= IF(NOT(ISBLANK(client_table[Client Meeting Date])) && NOT ISBLANK (client_table[picked up date]),NETWORKDAYS(client_table[Client Meeting Date],client_table[picked up date],1),BLANK())
 
Would appreciate some direction/help please ! Still learning the ropes of Power BI !


Many thanks in advance!
1 ACCEPTED SOLUTION
JoeBarry
Solution Sage
Solution Sage

Hi @Jays_D 

 

You can try this.

Networkdays = DATEDIFF(client_table[Client Meeting Date], client_table[picked up date], DAY)

Thanks

Joe

View solution in original post

4 REPLIES 4
LiMo
Regular Visitor

If using network days to exclude weekends, any suggestions rather than using datediff?

JoeBarry
Solution Sage
Solution Sage

Hi @Jays_D 

 

You can try this.

Networkdays = DATEDIFF(client_table[Client Meeting Date], client_table[picked up date], DAY)

Thanks

Joe

HI Joe, your suggestion wouldnt factor in weekends or holidays?

Thanks

I cannot believe how over complicated my DAX was !

This has solved it, thank so much @JoeBarry 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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