I Have the following table:
And I would like the same result as shown on my Pivot table with the measure EstanAA wich DAX formula is the Following:
Code: Select all
EstancAA:=CALCULATE([Estanc];SAMEPERIODLASTYEAR(Calendario[FECHA FOTO]);FILTER(ALL(InformeDiario[Año Query]);[Año Query]=2017))
The problem is I have filtered manually the field [Año Query]=2017 on my formula and I would like to have allways a previuos year shown on the AñoQuery filter.
Thanks for your help