Forum Discussion

JB's avatar
JB
Icon for Helper II rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper II rankHelper 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

     

    • JB's avatar
      JB
      Icon for Helper II rankHelper II
      3 years ago

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

      Thanks. 

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        3 years ago

        JB Whoops! Glad you got it figured out!