Forum Discussion
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...
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 Anonymous ,
I am not too clear about requirements. Can you create an excel sheet of dates with the result you are expecting and paste it here.
As requested by you to calculate the weekend date based on Saturday you can use the calculated column as
Column = [Date] - MOD([Date]-1, 7) + 6
The date here refers to the date column of your date table.
Cheers
CheenuSing