Networkdays - Use todays date if 2nd date is empty.

[StuartSmith]

I have the below measure that works out the week days between 2 days, but sometimes the 2nd date (position filled date), wont have a value, so how can I modify the below measure so that if the 2nd data parameter of "NETWORKDAYS" is blank, it uses todays date?

Weekdays = NETWORKDAYS('KPI Measures: Time to Fill'[(1) Position End Date], 'KPI Measures: Time to Fill'[(2) Position Filled Date]) +0

Thanks in advance,

[StuartSmith]

Can anyone help with this?

[StuartSmith]

I ended up using "

PositonFilledWithTodayIfBlank = IF ('User Archive'[Position Filled] = blank(), today(), 'User Archive'[Position Filled] )" to create a new column and used this.

[Greg_Deckler]

@StuartSmith Try:

Weekdays = 
  VAR __StartDate = 'KPI Measures: Time to Fill'[(1) Position End Date]
  VAR __End = 'KPI Measures: Time to Fill'[(2) Position Filled Date]
  VAR __EndDate = IF( __End = BLANK(), TODAY(), __End)
  VAR __Result = NETWORKDAYS( __StartDate, __EndDate) +0
RETURN
  __Result

[wendereis]

Hi @Greg_Deckler  @rajendraongole1 
This solution didn't work with me, as print below:

[StuartSmith]

Thanks, and your code makes perfect sense.  I must learn to breakdown the solution into smaller chunks.  That said, by adding the line that checks if the "Positon Filled" value is Blank, its doing something odd and creating lots more rows.  I have been able to replicate with dummy data and you can view a .pbix file below.

Time to Fill Position Filled Checker The file contains 2 tables visuals, 1 without th line to check if blank and 1 with.

Thanks in advance,