topic Re: How to achieve a full year, last year measure? in DAX Commands and Tips

How to achieve a full year, last year measure?

Anonymous — Fri, 22 Apr 2022 13:30:37 GMT

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?

Re: How to achieve a full year, last year measure?

Whitewater100 — Fri, 22 Apr 2022 13:49:55 GMT

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

Re: How to achieve a full year, last year measure?

v-yanjiang-msft — Thu, 28 Apr 2022 07:53:18 GMT

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.