How to achieve a full year, last year measure?

[Anonymous]

I need to achieve a FULL Year measure for Last Year.

To achieve that, I have to… Ignore the Month and Date filters, and somehow pick the ‘Fiscal Year’ selected value and do a -1 to it.

My filters:

For Full Year what I have is:

Sales Full Year:=



CALCULATE

([Sales] , ALL('Date'[FY & Month], 'Date'[Week Offset],'Date'[Date]))

This works fine!

But for Full Year Last Year I am doing this:

Sales Full Year LY:=

CALCULATE ( [Sales Full Year] , PARALLELPERIOD ( 'Date'[Date] , -12 , MONTH ) )

But it doesn’t work! How can I achieve my goal?

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, I create a sample.

Actually the PARALLELPERIOD can get the correct date period, but it can still be affected by the slicer, so it return blank.

Modify the formula to:

Sales Full Year LY =
CALCULATE (
    [Sales Full Year],
    PARALLELPERIOD ( 'Date'[Date], -12, MONTH ),
    ALL ( 'Date' )
)

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Whitewater100]

Hi:

Can this work? Example set up measures.

Sales = SUM(Sales[Sales Amt])

Sales Full Year = CALCULATE([Sales], FILTER(Dates, Dates[Year] = XXXX))  * you can choose the year, e.g. 2021

Sales Full Year LY:=

CALCULATE ( [Sales Full Year] , PARALLELPERIOD ( 'Date'[Date] , -1 , YEAR ) )

If you want to see a better over view, please see page 3 on the attached file. Here you can use the fields from the Date Table to also show you yearly sales. I hope this helps!

https://drive.google.com/file/d/1gHqCvtbQf3NeoFcVak_EF45cjH2kAiF8/view?usp=sharing