Cumulative SUM of working days

[Anonymous]

Hi community,

I need to calculate cumulative count of working days for the same period in last year .I already have a script which works fine for the current year , however can't get it done for the last year . In the screenshot attached,in PowerBI i filtered for 2023 year and calculation works fine . I want a measure which do the same for the same period in last year ,to put next to him.Thanks in advance.

My script  : 

Measure CurrentWorkingDays =

VAR CurrentDate = MAX('Календарь'[DayDate])

VAR SelectedMonth = MAX('Календарь'[MonthNo])

VAR WorkingDaysPast =

    CALCULATE(

        COUNTROWS('Календарь'),

        FILTER(

            ALLSELECTED('Календарь'),

            'Календарь'[DayDate] <= CurrentDate

                && 'Календарь'[MonthNo] = SelectedMonth

                && 'Календарь'[DayIsHolyday] = 0

        )

    )

    RETURN WorkingDaysPast

[Anonymous]

Hi,

Thanks for your quick response. It shows "Parameter is not the correct type" indicating to CurrentDate variable. 

[confidentnwrong]

Hello,

Assuming 'Календарь'[DayDate] is the whole date (eg 01/01/2023), here's how to adapt your measure up until the same date last year, using PARALLELPERIOD

Measure WorkingDaysLastYear =
VAR CurrentDate = MAX('Календарь'[DayDate])
VAR SelectedMonth = MAX('Календарь'[MonthNo])

VAR WorkingDaysPast =
    CALCULATE(
        COUNTROWS('Календарь'),
        FILTER(
            ALLSELECTED('Календарь'),
            'Календарь'[DayDate] <= PARALLELPERIOD(CurrentDate, 1, YEAR)
                && 'Календарь'[MonthNo] = SelectedMonth
                && 'Календарь'[DayIsHolyday] = 0
        )
    )
    RETURN WorkingDaysPast