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