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:

     

Ray_Minds's avatar
Ray_Minds
Solution Supplier
1 year ago

In Power BI, you can handle blank values in your measure or calculated column by using the IF and ISBLANK functions:

 

  1.  ISBLANK('Meetings'[1st Meeting]): Determines if the 1st Meeting column contains a blank value.
  2.  IF statement: If the 1st Meeting is blank, the formula outputs BLANK(). Otherwise, it computes the difference using the NETWORKDAYS function.
  3. Subtracting 1: Adjusts the result by subtracting 1 from the calculated value.

 


Did I answer your question? Mark my post as a solution!