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.
stuart765's avatar
stuart765
Frequent Visitor
3 years ago

I used the formula referenced and Previous Year Revenue did not return a value. It was blank.