Networkdays - How to calculate in PowerBI have tried other posts

[Anno2019]

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.

Country	Country GEO	Pick up Date	Delivery Date	Networkdays
Germany	Non Middle East	17 Jan 2020 Fri	20 Jan 2020 Mon	2
Ghana	Non Middle East	17 Jan 2020 Fri	20 Jan 2020 Mon	2
USA	Non Middle East	17 Jan 2020 Fri	20 Jan 2020 Mon	2
Egypt	Middle East	16 Jan 2020 Thu	19 Jan 2020 Sun	2
Qatar	Middle East	16 Jan 2020 Thu	19 Jan 2020 Sun	2

[v-yuta-msft · Accepted solution]

@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.