Number of Working Days

No, work Days for this year are correct but not for the last year.

Ok yes this is not going to work because you are using a time intelligence function with SAMEPERIODLASTYEAR. This will not work across workdays and weekends as its not set up to.

I’m a bit confused as to what you’re trying to achieve here.

Why do you need to know the last year date.

You should be able to utilise techniques used in the below example to achieve comparisons between different time frames.

It all involves using the FILTER function inside of CALCULATE correctly.