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

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

rajanimaddala ,

 

How about change your measure using dax below?

Booked Sales(SET) Last Year =
CALCULATE (
    SUM ( 'BI vwSETSales'[Actual Revenue] ),
    FILTER (
        ALL ( 'BI vwSETSales' ),
        'BI vwSETSales'[Source] = "WON_OPPS"
            && 'BI vwSETSales'[Product Group] IN VALUES ( 'BI vwProductGroup'[Target Group] )
    ),
    DATEADD ( 'BI vwSETSales'[Transaction Date], -1, YEAR )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • 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.