Sum Max Value and second Biggest Value

[Kemalnugraha]

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 Sold	Week
109	20
100	21
102	22
120	23
115	24
110	25
120	26
125	27

[harshnathani]

Hi @Kemalnugraha ,

You will need a Calendar Table with week.

Have a look at this blog. (pbix file is attached too).

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[AntrikshSharma · Accepted solution]

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