Forum Discussion

HishamAT's avatar
HishamAT
Helper II
3 years ago
Solved

Creating a measure for Delta

I wrote this code to calculate the delta ( Diffrance )between the current year for the current month from the previos year for the same month BUT unfortunately it gives me sysntax error "," Can you please help to figure out where is the problem and how to solve it 

 

Delta =
VAR CurrentMonth = MONTH(TODAY())
VAR CurrentYear = YEAR(TODAY())
VAR PreviousYear = CurrentYear - 1
RETURN
CALCULATE(
SUM(Sales[Amount]),
SAMEPERIODLASTYEAR('Date'[Date]),
YEAR('Date'[Date]) = PreviousYear,
MONTH('Date'[Date]) = CurrentMonth
) - CALCULATE(
SUM(Sales[Amount]),
YEAR('Date'[Date]) = CurrentYear,
MONTH('Date'[Date]) = CurrentMonth
)

 

 

Thanks.

  • Hi,

     

    it's actually an error with the variable 'PreviousYear ' this is a reserved word - if you change it and the references to it in the measure it will work.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar

    Hi,

     

    it's actually an error with the variable 'PreviousYear ' this is a reserved word - if you change it and the references to it in the measure it will work.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍