Forum Discussion
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...
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]))
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!