Forum Discussion
Filter on the measure.
Community ChampionAnonymous
2016 - ( 2016 - 1) => 1
FILTER (DMEGF_Ano; DMEGF_Ano [Year] = MAX (DMEGF_Ano [Year]) - (MAX (DMEGF_Ano [Year]) - 1)))
delete the underlined part
correct the error and the information is being displayed however when I do a filter annually whether in 2016, 2015 or 2014 values are blank
- Sean
are you using DMEFG_Ano[Year] for the Slicer?
yes, to correct that what you recommend? I create a dimenssão calendar?
- Sean
Do you have any other filters/slicers ON at the same time?
EDIT:
If you want to create a Date Table look here (Link by Matt)
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
Yes, my reports have several filters
- Sean
Anonymous I tried these formulas with several Slicers and it works.