Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |