error in formula dax

[Syndicate_Admin]

good afternoon, I have a design

I capture the year and month of the slicer, I need to get a value for the same period of a year before, for which I make the following formula

mes_ant = DATEADD(Hoja1[my],-1,YEAR)

where I subtract a year to the selected value, until there well because I get the following values

now I need to add the value of the column for that month I use this

total_mes_ant = calculate(SUM(Hoja1[Value]),FILTER(Hoja1,Hoja1[my]=[mes_ant]))

but with that formula it generates emptiness

but in the table if there data

what can be my mistake?

[Syndicate_Admin]

I currently only have one table as shown in the image

what I want is from selecting a month

get the value of the value column for a previous year and the previous month

[lbendlin]

You need to modify the filter context to include the full table, by using ALL() or similar.

[Syndicate_Admin]

hello, what a pity it is not very clear to me how to do it, you help me on the formula as serious that pity

total_mes_ant = calculate(SUM(Hoja1[Value]),FILTER(Hoja1,Hoja1[my]=[mes_ant]))

[lbendlin]

something like 

total_mes_ant = 
var mes_ant = EDATE(SELECTEDVALUE(Hoja1[my]),-12)
return calculate(SUM(Hoja1[Value]),ALLSELECTED(),Hoja1[my]=[mes_ant])

or

total_mes_ant = calculate(SUM(Hoja1[Value]),SAMEPERIODLASTYEAR(Hoja1[my]))

[Syndicate_Admin]

generates the following error

[lbendlin]

too many brackets

total_mes_ant = 
var mes_ant = EDATE(SELECTEDVALUE(Hoja1[my]),-12)
return calculate(SUM(Hoja1[Value]),ALLSELECTED(),Hoja1[my]=mes_ant)

[Syndicate_Admin]

hello indeed the formula is fine, but the value is still blank

[lbendlin]

https://urldefense.com/v3/__https://community.powerbi.com/t5/Desktop/error-in-formula-dax/m-p/256738...

[lbendlin]

- show your data model

- consider using SAMEPERIODLASTYEAR()