Prior Year Business Days Set Analysis

[ryanfoster84]

Hi,

I am using the following set analysis to calculate the business days Prior  YTD:

=Max(
{$<
Year = {$(=max(Year)-1)},
[Trade Date]={"<=$(=AddYears(max([Trade Date]),-1))"},

[Month Name] = {"<=$(=max({<Year={$(=max(Year))}>} [Month Name]))"}
>}
[Business Days YTD])

but i am encountering a problem. When i select May 2020 on my dashboard it is only returning 102 business days for May 2019 but it should in fact be returning 104 and the reason for this because May 2020 only had business days until the 29th May 2020 where as May 2019 had business days running until 31st May hence the 104 business days.

Can anyone assist?

Thanks,

Ryan

[hsalem65]

I have the same issue. Can someone help please!

[Brett_Bleess]

With no QVW file and no data model etc., it is going to be very difficult for anyone to really say why things are occurring in this case.

Regards,
Brett