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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anno2019
Helper IV
Helper IV

Networkdays - How to calculate in PowerBI have tried other posts

Hi Guru's

 

I need help please in calculating the network days between two dates.

Problem is that I need to take the [Country GEO] into consideration.

Non Middle East working day Mon to Fri

Middle East workding day Sun to Thu

 

I gained some traction with this post but not working for me.  I have read each past post on Networkdays but can't figure it out.

https://community.powerbi.com/t5/Desktop/Networkdays/m-p/139569#M60020 

 

Here is my pbix file for quick reference.  https://www.dropbox.com/s/yrivw73a12fyf7o/Networkdays%20INTL%20how%20to%20calculate.pbix?dl=0 

It does include a calendar table.

 

This is how my data looks, [Networkdays] is my desired calculated column or measure.

CountryCountry GEOPick up DateDelivery DateNetworkdays
GermanyNon Middle East17 Jan 2020 Fri20 Jan 2020 Mon2
GhanaNon Middle East17 Jan 2020 Fri20 Jan 2020 Mon2
USANon Middle East17 Jan 2020 Fri20 Jan 2020 Mon2
EgyptMiddle East16 Jan 2020 Thu19 Jan 2020 Sun2
QatarMiddle East16 Jan 2020 Thu19 Jan 2020 Sun2
1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anno2019 ,

 

You can refer to blogs below about using DAX and power query to generate the net work day column.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/td-p/367362

https://www.powerquery.training/networkdays/

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@Anno2019 ,

 

You can refer to blogs below about using DAX and power query to generate the net work day column.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/td-p/367362

https://www.powerquery.training/networkdays/

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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