Forum Discussion

Elisa112's avatar
Elisa112
Icon for Helper V rankHelper 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:

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
1 year ago

Hi Elisa112 ,

 

From the syntax I believe you are creating a column you can try something similar to this:

 

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