Forum Discussion
Time measures excluding weekends
Hello Power BI experts! I am looking for help on some time calculations. I am fairly new to Power bi so would need step to step guide (teaching a baby to walk👶) Date table below: Scenario 1:...
Hi again,
I have tried all links with no success.
The dax code, seems to be the closest thing but an error comes up: the start or end date in calendar function can not be blank. Even if I put the created date and completed date.
Working Hours =
VAR filtered =
FILTER (
ADDCOLUMNS (
CROSSJOIN (
CALENDAR ( [Created Date],[Completed Date] ),
With the exceptions, I was thought that the "timer" would count from the next date or time ie Mon-FRi 8am-5pm.
Thanks,
Lexi
