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!

Anonymous's avatar
Anonymous
Not applicable
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!

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

Seems like already solved it. Typically same week day is 364 days behind. As you already have formula to find week end date you can use that on date that is 364 days behind.

Can you mark you reply as solution, so that other can take hekp