Forum Discussion

Elisa112's avatar
Elisa112
Helper V
1 year ago
Solved

Networkdays function with blank start dates

Hi Experts    I am using the network days function :   Meeting date diff= NETWORKDAYS('Meetings'[1st Meeting],'Meetings'[2nd Meeting])-1 However some of the 1st meetings in the column are blank...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    Hi Elisa112 ,

     

    Do you mean on the visualization level? You just need to select show items with no values for the column you want to have that information:

     

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

Elisa112 

Calculated column


Meeting date diff = 
IF(
ISBLANK('Meetings'[1st Meeting]), 
BLANK(), 
NETWORKDAYS('Meetings'[1st Meeting], 'Meetings'[2nd Meeting]) - 1
)

💌If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn