Forum Discussion

maurcoll's avatar
maurcoll
Helper IV
1 year ago
Solved

Week comparison same week last year

Hi i need to create the below table the issue i have is that the week isnt bringing back the same week number last year it is bringing back the same date range. For example for week 11-17 Nov 24 i w...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi maurcoll,

    Try this checks to fix the issue

    If your current WeekIndex is, for example, 210, but there’s no data available for index 158 (210 - 52), then the CALCULATE function won’t find a match — resulting in a blank output.

    Test Last Year WeekIndex = SELECTEDVALUE('Calendar'[WeekIndex]) - 52

    Now, place the following in a table visual: 'Calendar'[Start of Week],'Calendar'[WeekIndex]


    Is WeekIndex a whole number?
    Is 'Start of Week' unique per row?
    Is the relationship on 'Date', not 'Start of Week'?
    Are you using MAX() instead of SELECTEDVALUE() in visuals?
    Does WeekIndex - 52 exist in your calendar table?

     

    Thank you & Regards,
    Prasanna kumar

lbendlin's avatar
lbendlin
Super User
1 year ago

If you truly want to compare the same weeks between current and previous year then your only option is to subtract 364 from the date.  That is the only true correct comparison.