Calculating Networkdays if it's blank in Power Query

[Bukhori]

Hi Everyone,

I would to calculate networkdays between the [Start] and [End]. the formulla went well with 

Networkdays([Start],[End],Holiday)

but in case [End] = null 

I've tried to replace null with today() [similar like excel] by writing 

Networkdays([Start],if [End] = null then DateTime.LocalNow else [End],Holiday)

Error show up as it seems wrong format. I've tried to put Date.From as well but it isn't work 

Networkdays([Start],if [End] = null then Date.From(DateTime.LocalNow) else [End],Holiday)

Your advice much be appreciated. Thank you so much in advance.

[tackytechtom · Accepted solution]

Hi @Bukhori ,

How about this:

if [End] = null then Networkdays([Start], Date.From(DateTime.LocalNow()), Holiday) else Networkdays([Start], [End], Holiday)

Let me know 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Bukhori]

Hi @tackytechtom ,

This is working fine!
Thank you so much for your assistance.