topic Re: Calculated column repeats value until it is updated in DAX Commands and Tips

Calculated column repeats value until it is updated

JB — Thu, 15 Jun 2023 14:08:35 GMT

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.

Re: Calculated column repeats value until it is updated

Greg_Deckler — Thu, 15 Jun 2023 14:40:34 GMT

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

Re: Calculated column repeats value until it is updated

JB — Thu, 15 Jun 2023 14:49:47 GMT

Hi Greg, thanks for your reply.

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

Re: Calculated column repeats value until it is updated

JB — Thu, 15 Jun 2023 15:39:30 GMT

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

Thanks.

Re: Calculated column repeats value until it is updated

Greg_Deckler — Thu, 15 Jun 2023 18:57:31 GMT

JB Whoops! Glad you got it figured out!