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? so the Delta always showing update compared to last week when I put this measurement in a card
the thing is week column's format is just number

 

Total SoldWeek
10920
10021
10222
12023
11524
11025
12026
12527
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

2 Replies

  • 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