Forum Discussion

stuart765's avatar
stuart765
Frequent Visitor
3 years ago
Solved

SAMEPERIODLASTYEAR Problem

  I am attempting to create a dashboard (cards) showing current year revenue (SP Revenue CY) vs. previous year revenue (SP Revenue Previous Year) and have the DAX commands listed below for each. ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi stuart765 

    try like:

    SP Revenue Previous Year = 
    CALCULATE(
        SPTable [SP Revenue CY],
        DATEADD(CalendarTable[Date], -1, MONTH)
    )
     
    Please let me know if it works, then we say why SAMEPERIODLASTYEAR is not working.
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi stuart765 

try like:

SP Revenue Previous Year = 
CALCULATE(
    SPTable [SP Revenue CY],
    DATEADD(CalendarTable[Date], -1, MONTH)
)
 
Please let me know if it works, then we say why SAMEPERIODLASTYEAR is not working.