Forum Discussion

JB's avatar
JB
Helper II
3 years ago
Solved

Calculated column repeats value until it is updated

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.
"Calculated Column"
  • JB's avatar
    JB
    3 years ago

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

    Thanks. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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's avatar
JB
Helper II
3 years ago

Hi Greg, thanks for your reply.

 

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