Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |