Business Days Between two Dates

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

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

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.

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?

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.

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

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

I agree to this