Forum Discussion

hcvb07's avatar
hcvb07
Frequent Visitor
6 years ago

Calculating Business Days without Calendar or Table Editing

Hi all!   Fairly new to Power BI and hoping someone can help me out.  I've been looking through some suggestions but I can't find any articles that help.  I'm trying to calculate Business Days (AKA...
Need Help
hcvb07's avatar
hcvb07
Frequent Visitor
6 years ago

Thanks for the attachment!  Based on my data, I can only use Ways 3 or 4 (I can't make calculated columns because I have a live connection).  However, both of those still result in calendar days not business days.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    hcvb07 , it is on page 2 or working day page 

    Working Days = CALCULATE(Sum('Date'[Working day]),VALUES('Order Dim'[Order No]),filter(all('Date'),'Date'[Date]>=[Min Order Date OD] && 'Date'[Date] <=[Max Deilvery OD]))
    • hcvb07's avatar
      hcvb07
      Frequent Visitor
      6 years ago

      My problem is that I don't have a calculated column that indicates 'Working Day' - I don't have a calendar table available and I can't create one since I have a live connection.  So I would need an alternative way to sum working days without creating a calculated column.  Appreciate the help and quick response!