Calculated column repeats value until it is updated

[JB]

Hi,

I'd like a calculated column that repeats the last given value until it is updated. See below for an example. 

Many thanks for your help.

[Greg_Deckler]

@JB Try:

Last updated tons column =
  VAR __Date = [Week Ending Date]
  VAR __LastDate = MINX( FILTER( 'Table', [Tons] <> BLANK() && [Week Ending Date] <= __Date ), [Week Ending Date] )
  VAR __LastTons = MINX( FILTER( 'Table' [Week Ending Date] = __LastDate ), [Tons] )
RETURN
  __LastTons

[JB]

Hi Greg, thanks for your reply.

Unfortunately it is repeating the first value found rather than updating them weekly, see below

[JB · Accepted solution]

@Greg_Deckler 
Fixed it, just needed to change MINX to MAXX.

Thanks. 

[Greg_Deckler]

@JB Whoops! Glad you got it figured out!