Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating Last Week Last Year

Hi all,   I am trying to create a measure that returns the week end date last year. The week end date is always need to be on a Saturday, which causes some problems when trying to account for the o...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    I managed to figure it out - maybe I wasn't so clear on the explanation but the end result might help! Here is the measure I ended up with:

     

    LOOKUPVALUE('DimensionDate'[Week End Date],'DimensionDate'[Year & Cal WeekNum],VALUES('DimensionDate'[Year & Cal WeekNum])-100)

     

    This returns the week end date for last year - just need to factor in years with 53 weeks and then I am all set.

     

    Thanks for the advice though!