Forum Discussion
Syndicate_Admin
Administrator
Administratorerror in formula dax
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 = D...
lbendlin
Super User
Super Usersomething 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_AdminAdministrator
Administratorgenerates the following error