Like for Like Same Store Sales RRS feed

  • Question

  • Hi,
    Can anyone could help me?

    I want to calculate total Revenue for Same Stores. Requirement is that if it is filtered date from 05/01/2020 to 05/19/20 then it  must be calculated for last year only 19 days  05/01/2019 -05/19/2019 . not 31 days for last year. Because, this year We have only 19 days sales for may 2020 but  we have 31 days Sales for 2019. I want to calculate  sales for same days for both year. There should be considered that in every month new stores are opened or closed based on their sales.

    I have used Dateadd, sameperiodlastyear and so on, but when I filter date from 05/01/2020 to 05/19/2020, It is shown only for 2020, 2019 Sales disappeared.

    Note, Date slicer must be change dynamically, It can be chosen any date period  for example 05/05/2020  - 05/25/2020

    Thanks in advance
    Tuesday, May 19, 2020 4:54 PM

All replies