Skip to main content

    Power BI

    Needs Votes

    Business Days Between two Dates

    Vote (46) Share
    's profile image

    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)
    's profile image Profile Picture

    jatphat on 06 Jul 2020 00:04:54

    RE: Business Days Between two Dates

    I agree to this

    's profile image Profile Picture

    Keith on 05 Jul 2020 23:38:44

    RE: Business Days Between two Dates

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

    's profile image Profile Picture

    Devon Summers on 05 Jul 2020 23:13:06

    RE: Business Days Between two Dates

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

    's profile image Profile Picture

    Gonzalo Salines on 05 Jul 2020 22:59:52

    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.

    's profile image Profile Picture

    Marek on 05 Jul 2020 22:49:53

    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?

    's profile image Profile Picture

    Sean Kew on 05 Jul 2020 22:48:03

    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.

    's profile image Profile Picture

    Karim on 05 Jul 2020 22:45:35

    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

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:33:22

    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