SAMEPERIODLASTYEAR - How to disallow filters on several YEARS RRS feed

  • Question

  • Hi,

    I have report showing sales numbers and Im using formula SAMEPERIODLASTYEAR. In the date slicer in Excel the users can choose dates with overlapping years, and then the formula SAMEPERIODLASTYEAR wont make any sense. Is there any way to disallow this i Pover Pivot / Excel?

    Wednesday, January 22, 2020 10:58 AM

All replies