Forum Discussion

hsalasde's avatar
hsalasde
Regular Visitor
2 years ago

Previous Year Calculations

Hello, 

 

I'm attempting to calculate Previous Year measures using SAMEPARIODLASTYEAR & by using Filsters. In both instances, the calculations are wrong. The data shows that the calculations made by Power BI are off by a day. The period for the current year is calculated from Sunday through Saturday. The Previous Year calculation is calculating from the previous Saturday through Friday. I've looked through board to find a solution, but I'm stumped. 

 

Here are my two different calculations which are giving the same result. 

 
Using DATESINPERIOD: 
PY Weekend Surg Mins w/ Filter =
CALCULATE(
    [Weekend Surg Mins],
    FILTER(
        DATESINPERIOD(
            'Date'[Date],
            DATEADD(
                LASTDATE('Date'[Date]),
                -1,
                YEAR
            ),
            -7,
            DAY
        ),
        WEEKDAY('Date'[Date], 1) IN {2,6,7,1}
    )
)
 
Using SAMEPERIODLASTYEAR:
PY Weekend Surg Mins =
CALCULATE(
    [Weekend Surg Mins],
    SAMEPERIODLASTYEAR('Date'[Date])
    )
 
Any help would be most appreciated! 
 
Manual ReviewPower BI Table Output
 
 

1 Reply