Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Bukhori
Frequent Visitor

Calculating Networkdays if it's blank in Power Query

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.

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Hi @tackytechtom ,

 

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors