on 26 Feb 2016 01:48:27
It would be nice to know the number of business days between two dates as opposed to the entire week when not much work is completed on the weekend.
- Comments (8)
RE: Business Days Between two Dates
I agree to this
RE: Business Days Between two Dates
I want to know simple things, like delivery date to bill date and bill date to date paid.
RE: Business Days Between two Dates
Crazy this isn't a priority. DAX workarounds are unreliable at best. It's an essential function.
RE: Business Days Between two Dates
I agree with all comments on this threat. It'¡s Hard to believe that PowerBI has not a build-in function to calculate business Days between two dates. Very difficult to calculate KPI with out this. All workarounds in the community are very complicated and not very handy.
RE: Business Days Between two Dates
It's very interesting, that only a few people found this useful by voting..... Can't believe, that no one calculates the number of business days between two dates. Quick example: turn around time: order receipt date vs order ship date. How do I calculate/show it in PowerBI?
RE: Business Days Between two Dates
I agree, powerbi should have something similar to the networkdays excel function (also allowing the user to define holidays) since it makes kpi calculation using dates much more useful.
RE: Business Days Between two Dates
I saw several solution on the community where you have to create another table + a SUMX formula with 2 filters.... doesn't make sense. Excel has this function! plz make this happen. Thanks
RE: Business Days Between two Dates
also why would does the result in days have to be 30.00 it should be while numbers please