Hi @Neville,
The time intelligence functions in PowerBI will not work properly without a complete date table.
I added a full date table as provided Here
I then added a column for working days ( does not consider holidays) to the calendar.
Once that was done, I was able to add the below formulas:
WD_Revised =
CALCULATE(COUNTROWS(‘Calendar’),
FILTER(VALUES(‘Calendar’[IsWorkday]),‘Calendar’[IsWorkday] =1)
)
LY_WD =
CALCULATE([WD_Revised],
SAMEPERIODLASTYEAR(‘Calendar’[C_Date])
)
And then to test if I was getting the correct results
WD_Between =
CALCULATE([WD_Revised],
DATESBETWEEN(‘Calendar’[C_Date],“04/01/2019”,“06/08/2019”)
)
Below are my results:
My sample file SamePeriodLastYear-WorkingDays__Revised.pbix (151.6 KB)
I hope this helps.
Jamie