Count number of days in Status less Non-Working Days

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())
)

I found the answer by changing the DateDiffDays to DateDiffWorkdays resolved the issue

1 Like

Hi Brian T
I wanted to know if you could guide me by example to see the subject of the cases in each column and the colors I assume at the date of the consultation

CASE
WHEN
DateDiffWorkdays (now (), [Measures]. [Actual End Date]) <= 0
THEN
0
ELSE
DateDiffWorkdays (now (), [Measures]. [End Date])
END

or somewhere to see this information
Thank you very much and good weekend