I have a report that I capture the number days in a status but currently include weekends and Holidays and want to generate a report that excludes Saturday and Sunday. I see that there is a non workdays that I can exclude Saturday and Sunday - I have tried to add , ‘67’ to the date differences but get error
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues due] > 0
AND
Cache(DateDiffDays([Measures].[Issue status updated date], Now())) >= 1
),
DateDiffDays([Measures].[Issue status updated date], Now())
)