NETWORKDAYS - Use Today() if End Date is Blank

[Iceshade]

Hi All,

Quite new to Power BI and absolutely loving it !
I am working with a dashboard and trying to determine # of network days between 2 dates. Where the end date is Blank, I cannot work out how to use Today's date if it is blank.

Any guidance please would be greatly appreciated.

 

[footoo]

=NETWORKDAYS(A1,IF(B1="",TODAY(),B1))

 

[Iceshade]

=NETWORKDAYS(A1,IF(B1="",TODAY(),B1))

Thank you - I tried this however it seems to use "" as text and DAX throws an error that it can't do a comparison between date column and text column.

 

[Iceshade]

Hi All,

Quite new to Power BI and absolutely loving it !
I am working with a dashboard and trying to determine # of network days between 2 dates. Where the end date is Blank, I cannot work out how to use Today's date if it is blank.

Any guidance please would be greatly appreciated.

I think I have worked it out:
=NETWORKDAYS([Start Date],IF([End Date]= BLANK(),TODAY(),[End Date]))