Dynamic lastdecember results.

[Anonymous]

 

Hello everyone,

I'm working on a dax that measures the results of Lastdecember revenue by selecting the year.  My dax formula is : 

A = CALCULATE(CALCULATE([Total Non-Quality],LASTDATE('Calendar'[Year/Month])),PARALLELPERIOD('Calendar'[Year/Month],-1,YEAR))

when I apply this formula I obtain these results by filtering on sites: Last December results = 14.98 (of 2018) for one site and the global is 27.81 (of 2018)

When I change this formula to select Last December revenue for each year it doesn't work especially when I filter by sites. So the formula that I used is : 

B = CALCULATE([Total Non-Quality],FILTER(ALL('Quality 12MR'),YEAR('Quality 12MR'[Date])=SELECTEDVALUE('Calendar'[Year/Month].[Year])-1 && MONTH('Quality 12MR'[Date])=12))

the results that I obtain are Last December results = 27.81 (of 2018) for one site and the global is 27.81 (of  2018) when I don't apply site as a filter, so it doesn't filter by site. 

Thank you for the response.

Best regards. 

[Anonymous · Accepted solution]

 @Mariusz