Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
3 years ago
Solved

NETWORKDAYS - Display empty/blank cell if "End" date is empty.

I have the below measure...

 

Business Day to Backfill = NETWORKDAYS('KPI Measures: Backfill'[First Day Absent], 'KPI Measures: Backfill'[First Backfill Date])
 
but sometimes the 2nd date is empty and therefore the cell displays the date networkdays for "30/12/1899".
 

Is it possible to have the cell black/empty if no end date for the "NETWORKDAYS" parameter contains no date.

Thanks in advance.

Need Help
  • StuartSmith's avatar
    StuartSmith
    3 years ago
    I figured it out... _Business Day to Backfill = IF(ISBLANK('KPI Measures: Backfill'[First Backfill Date]), BLANK(), NETWORKDAYS('KPI Measures: Backfill'[First Day Absent], 'KPI Measures: Backfill'[First Backfill Date]))

1 Reply

  • StuartSmith's avatar
    StuartSmith
    Icon for Power Participant rankPower Participant
    3 years ago
    I figured it out... _Business Day to Backfill = IF(ISBLANK('KPI Measures: Backfill'[First Backfill Date]), BLANK(), NETWORKDAYS('KPI Measures: Backfill'[First Day Absent], 'KPI Measures: Backfill'[First Backfill Date]))