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

     

rajanimaddala's avatar
rajanimaddala
Helper II
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

 

Severofm's avatar
Severofm
Kudo Kingpin
2 years ago

Thank you very much, I've been trying for a long time to solve this error problem and with your solution of using 'PARALLELPERIOD' it was solved.