Forum Discussion
Calculating Last Week Last Year
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!
Hi,
Thank you for your quick responses and apologies for not explaining it very well. It is my first post here so thanks for explaining how to get posts answered Greg_Deckler
I have uploaded a sample file to dropbox (https://www.dropbox.com/s/1l2xpcc1z2lje5o/Last%20Week%20Last%20Year%20Example.xlsx?dl=0)
Column E contains the expected result, but ideally it would be good to have it as a measure rather than a calculated column.
I hope that helps and thanks again!
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
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
