Forum Discussion

Kemalnugraha's avatar
Kemalnugraha
Frequent Visitor
6 years ago
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?...
Need Help
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    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
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

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