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"

4 Replies

  • 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