Forum Discussion

bradbel's avatar
bradbel
Frequent Visitor
8 months ago
Solved

SAMEPERIODLASTYEAR and Week Number Groupings/Calculations Not Returning Expected Result

I am currently trying to set up a bar and line chart showing CY and PY sales data, grouped into week numbers on the X axis. The issue is that the SAMEPERIODLASTYEAR function is returning the incorrec...
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    8 months ago

    Hi bradbel ,

     

    Try below:

    PY Sales (Week Match) = 
VAR CurrentWeekNum = SELECTEDVALUE('Date'[WeekNum])
VAR CurrentYear = SELECTEDVALUE('Date'[Year])

RETURN
    CALCULATE(
        [Total Sales],
        ALL('Date'), -- Remove existing filters
        'Date'[Year] = CurrentYear - 1,
        'Date'[WeekNum] = CurrentWeekNum -- Forces Week 1 to match Week 1, ignoring 53rd weeks
    )

    this forces you to go to last year and apply the same weekfilter.

    Please give kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    Praful

     

Praful_Potphode's avatar
Praful_Potphode
Super User
8 months ago

Hi bradbel ,

 

Try below:

PY Sales (Week Match) = 
VAR CurrentWeekNum = SELECTEDVALUE('Date'[WeekNum])
VAR CurrentYear = SELECTEDVALUE('Date'[Year])

RETURN
    CALCULATE(
        [Total Sales],
        ALL('Date'), -- Remove existing filters
        'Date'[Year] = CurrentYear - 1,
        'Date'[WeekNum] = CurrentWeekNum -- Forces Week 1 to match Week 1, ignoring 53rd weeks
    )

this forces you to go to last year and apply the same weekfilter.

Please give kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful

 

  • bradbel's avatar
    bradbel
    Frequent Visitor
    8 months ago

    This is incredible - solution verified, data now aligns exactly how I wanted it to. Thank you so much for the quick response!