Time Calculations - Pr Yr formula not working

[cgoldstein]

Hello!

I'm working on creating my first report in PowerBi and have had to use metric time calculations due to my ISO calendar 4-4-5 which goes across years. I've been able to create metrics such as "YTD units" that are pulling back correctly, but for my "Prior YTD" metrics, it does not seem to be working and I don't know what I am missing.

I've checked and my fiscal_year_nr is formatted as #, so it should be able to subtract. 

YTD Formula that is working:

FYTD Units = IF (
HASONEVALUE ( 'Date'[Fiscal_year_nr] ),
CALCULATE (
SUM ( Invoice_Detail[Units] ),
FILTER (
ALL( 'Date' ),
'Date'[Fiscal_year_nr] = VALUES ( 'Date'[Fiscal_year_nr] )
&& 'Date'[Date] <= MAX ( 'Date'[Date] )
)
),
BLANK ()
)

Prior Year To Date formula (NOT WORKING):

PYTD Units =
IF (
HASONEVALUE ( 'Date'[Fiscal_year_nr] ),
CALCULATE (
SUM (Invoice_Detail[Units]),
FILTER (
ALL ( 'Date' ),
'Date'[Fiscal_year_nr] = VALUES ( 'Date'[Fiscal_year_nr] ) - 1
&& 'Date'[Date] <= MAX ( 'Date'[Date] )
)
),
BLANK ()
)

Thank you

[jthomson]

What results are you actually getting that make you think it's not working? The two formulas look identical

[cgoldstein]

Sorry- must have copied the Pr YTD formula incorrectly, I've updated it in the post. 

The formula is returning the Prior Year number, however it is returning the FULL month number vs. the "to-date" prior month. For example, it is pulling data for October last year and not October last year through 10/18.

Thank you!