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

[StuartSmith]

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.

[StuartSmith · Accepted solution]

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]))