Forum Discussion
Solved
Sum Max Value and second Biggest Value
Hi, I'm trying to make this measurement automatically update every week Delta Sold = (Sales[Total Sold](Sales[Week]=27))-(Sales[Total Sold](Sales[Week]=26)) how should I replace that number?...
Try something like this.
Measure = VAR LastVisibleWeek = MAX ( Sales[Week] ) VAR PreviousWeek = LastVisibleWeek - 1 VAR AmountForCurrentWeek = CALCULATE ( SUM ( Sales[Total Sold] ), Sales[Week] = LastVisibleWeek ) VAR AmountForPreviousWeek = CALCULATE ( SUM ( Sales[Total Sold] ), Sales[Week] = PreviousWeek ) VAR Result = AmountForCurrentWeek - AmountForPreviousWeek RETURN Result
Hi Kemalnugraha ,
You will need a Calendar Table with week.
Have a look at this blog. (pbix file is attached too).
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!