Business Days Between two Dates

[pbiideas1]

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.

[pieter_pelser]

also why would does the result in days have to be 30.00 it should be while numbers please

[karim3]

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

[Seankew]

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.

[mrqs]

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?

[v-gosali]

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.

[undercaste]

Crazy this isn't a priority. DAX workarounds are unreliable at best. It's an essential function.

[kmargelowsky]

I want to know simple things, like delivery date to bill date and bill date to date paid.

[japthat]

I agree to this