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.
Dear Community
I am very gnew ot this so whilst there are solutions on this page I simply cannot understand them. What I need to do is calculate the number of working days between two dates - even when the end date is before the start date. The context is:
RFQDate is the date that the customer asks for the quotation
QTDate is the date we send the quotation
We have a KPI of 5 working days to send the quotation
If the customer asks for the quotation on Thur 24/11 and we send it on Tue 29/11 then this is 4 working days BUT
The formula to calc the diff between two dates will give more days because it counts the weekend
What simple column formula will give me the number of working days between the two dates?
I dont understand functions or SQL very much so I need a really "numpty" explanation please. ManyThanks
You should post in other forums but not Issues for need help topic. I’d like to provide following topics which already have right answers with detailed measure/column formulas to you. You should be able to get the final result just by following the steps in them.
https://community.powerbi.com/t5/Desktop/Number-of-working-days/m-p/22842/highlight/true#M7236
Best Regards,
Herbert
Check out this Blog on PowerPivotPro.
https://www.powerpivotpro.com/2012/11/networkdays-equivalent-in-powerpivot/
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |