Forum Discussion
Datesbetween with filter excluding weekends
- Anonymous3 years ago
Hi bryn987 ,
Please try this:AVG Resolved Days = VAR _date1 = 'Sales'[Created] + 1 VAR _date2 = 'Sales'[Resolved] VAR _count = COUNTROWS ( CALCULATETABLE ( VALUES ( 'Date'[Date] ), FILTER ( ALL ( 'Date' ), 'Date'[IsWorkingDay] = TRUE () && 'Date'[Date] >= _date1 && 'Date'[Date] <= _date2 ) ) ) RETURN _countBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi bryn987 ,
Please try this:
AVG Resolved Days =
VAR _date1 = 'Sales'[Created] + 1
VAR _date2 = 'Sales'[Resolved]
VAR _count =
COUNTROWS (
CALCULATETABLE (
VALUES ( 'Date'[Date] ),
FILTER (
ALL ( 'Date' ),
'Date'[IsWorkingDay] = TRUE ()
&& 'Date'[Date] >= _date1
&& 'Date'[Date] <= _date2
)
)
)
RETURN
_count
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- bryn9873 years agoHelper I
Thank you Gao!