Last week today - last year drill down to day results
Hei, I hope you can help me. I need to create a measure that brings data per day for Last week - last year. So far I've managed to bring data per week with this measure: LWTD LY := VAR CurrentWeek = MAX(Time[WeekNr]) VAR CurrentYear = MAX (Time[Year]) VAR PriorYear = IF(CurrentWeek =1, CurrentYear-1, CurrentYear) VAR PriorWeek = IF(CurrentWeek=1, CALCULATE( MAX(Time[WeekNr]),ALL(Time), Time[Year]=PriorYear),CurrentWeek-1) RETURN CALCULATE([Sales],ALL(Time), Time[Year]=PriorYear, Time[WeekNr]=PriorWeek) This gives me the following results where the totals of the week sums are correct. However what I need is to bring data per date, not only the total of the week. How can I achieve this?
