Calculate the value of a specific past month and set it for all current months

[Anonymous]

Hi, I'm trying to create a measure that would calculate the value of previous december for all current month. 

So far I managed to get the value of past december 2018 for the current december 2019 month with the following Dax formula : 

CALCULATE(Table[Value];FILTER(ALL(Date);Date[Month_NB]=12);SAMEPERIODLASTYEAR(Date[Date])) 

But I would like to get the same December 2018 value in all month starting from January to december 2019. 

Thanks 

[az38 · Accepted solution]

Hi @Anonymous 

try

CALCULATE(Table[KPI Value];FILTER(ALL(Date);Date[Month_NB]=12 && YEAR(Date[Date])=YEAR(SELECTEDVALUE(Date[Date]))-1) ) 

[Anonymous]

Thanks it works fine !