Hello - I am using Sam’s week over week change formula from one of his YouTube videos. In my case, I am using it for showing the total of returns from one week, to the next. For example.
Week Number Qty to Return % Diff from prior week
27 34 23%
28 12 64%
What I would like to do, is have a separate measure that calculates the % difference between the weeks. So in the example above, the Week 28 percent difference (from Week 27) would be 64%. Any help is appreciated!
Week over Week2 =
VAR CurrentWeek = SELECTEDVALUE(‘Date Table’[Week Number])
VAR CurrentYear = SELECTEDVALUE(‘Date Table’[Year])
VAR MaxWeekNumber = CALCULATE(MAX(‘Date Table’[Week Number]), ALL(‘Date Table’))
IF(CurrentWeek = 1,‘Date Table’[Week Number]=MaxWeekNumber && ‘Date Table’[Year]=CurrentYear - 1,‘Date Table’[Week Number]=CurrentWeek - 1 && ‘Date Table’[Year]=CurrentYear)),[SumX Qty to Return])