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:

     

Elisa112's avatar
Elisa112
Icon for Helper V rankHelper V
1 year ago

MFelix Kedar_Pande Thanks for your help, I actually used conditional formatting to hide the incorrect values from appearing