Forum Discussion

Elina_Mirin's avatar
Elina_Mirin
Advocate II
2 years ago
Solved

Current Week versus Same Week Last Year

Hello all,   I am trying to create a custom measure in order to get same week from last year. I work with US calendar and every week restarts on Sunday. Also some years have 52 weeks, others have 5...
Need Help
Show and Tell
Tips and Tricks
  • mh2587's avatar
    mh2587
    2 years ago
    MeasureSameWeekLastYear = //Try this one might help you
VAR CurrentYearWeek = CONCATENATE(MAX('YourTable'[Year]), "-", MAX('YourTable'[WeekNumber]))
VAR PreviousYearWeek = CONCATENATE(MAX('YourTable'[Year]) - 1, "-", MAX('YourTable'[WeekNumber]))
RETURN
CALCULATE(
    [YourMeasure],
    FILTER(
        ALL('YourTable'),
        'YourTable'[YearWeek] = PreviousYearWeek
    )
)
mh2587's avatar
mh2587
Super User
2 years ago
MeasureSameWeekLastYear = //Try this one might help you
VAR CurrentYearWeek = CONCATENATE(MAX('YourTable'[Year]), "-", MAX('YourTable'[WeekNumber]))
VAR PreviousYearWeek = CONCATENATE(MAX('YourTable'[Year]) - 1, "-", MAX('YourTable'[WeekNumber]))
RETURN
CALCULATE(
    [YourMeasure],
    FILTER(
        ALL('YourTable'),
        'YourTable'[YearWeek] = PreviousYearWeek
    )
)
  • Elina_Mirin's avatar
    Elina_Mirin
    Advocate II
    2 years ago

    Hi,

     

    Thank you for the quick answer! However, this measures seems not to work. I cannot declare the 2 VARs, as it says the sintax is incorrect.