Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

error 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...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

I currently only have one table as shown in the image

mancemo_0-1654696851970.png

what I want is from selecting a month

mancemo_1-1654696893316.png

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    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's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      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's avatar
        Syndicate_Admin
        Icon for Administrator rankAdministrator
        4 years ago

        generates the following error

        mancemo_0-1654705737697.png