Forum Discussion

rajanimaddala's avatar
rajanimaddala
Helper II
6 years ago
Solved

SAMEPERIODLASTYEAR error

Hi I have sales table, product table and calendar table   I have slicers for FY, Month and Product I need to get last year sales value for the current month selected. This is my DAX expression ...
Need Help
  • rajanimaddala's avatar
    rajanimaddala
    6 years ago

    Hi

    Thanks for the reply. I am getting the same error "DATEADD can be used only when contiguous dates exist..."

     

    I have used PARALLELPERIOD(BI vwSETSales[Transaction Date], -12, MONTH) and it worked

     

mussaenda's avatar
mussaenda
Community Champion
6 years ago

Change your transaction date to your date from calendar  table

  • rajanimaddala's avatar
    rajanimaddala
    Helper II
    6 years ago

    Hi,

     

    Thanks for the reply. I have tried but it is calculating SUM(vwSETSales[Actual Revenue]) from entire resutset

    No filters applied.