Forum Discussion
Same week previous year
Hi I have create a measure to get the sum of sale from previous year same week as IF ( HASONEVALUE (DAT[CalendarYear]), CALCULATE (SUM ([CA]), FILTER (ALL ( D...
Sorry,
I forgot the give the DAT table structure
CalendarYear Integer -> Year
WeekNumberOfYear -> Integer -> Week number (1 to 53)
FullAlternateDate -> Date
MonthNumber Integer -> Month
at least