Fill in gaps in meter reading table

[Anonymous]

Hi,

I really stuck here to fill in the gap. I failed to use LASTNONBLANKVALUE, Please help!!

[v-luwang-msft · Accepted solution]

HI @Anonymous ,

Test the below to create a new column:

newaverage =
IF (
'Table'[average] = BLANK (),
CALCULATE (
MAX ( 'Table'[average] ),
FILTER (
ALL ( 'Table' ),
'Table'[average] <> BLANK ()
&& 'Table'[Date] >= EARLIER ( 'Table'[Date] )
)
),
'Table'[average]
)

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Anonymous]

I just checked your result, there is a bug need to debug.

[v-luwang-msft]

Hi @Anonymous ,

Thank you for pointing this out, I have made the adjustment, see below：

newaverage = 
VAR MAXDATE =
    CALCULATE (
        MIN ( 'Table'[Date] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[average] <> BLANK ()
                && 'Table'[Date] >= EARLIER ( 'Table'[Date] )
        )
    )
RETURN
    CALCULATE (
        MAX ( 'Table'[average] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Date] = MAXDATE )
    )

Best Regards

Lucien

[speedramps]

Hi  babyjb123

You have given very little infomation. Please give detailed infomation when postng question on the forum. Thank you. Have you tried using Fill down in the columns in the query editor?

PREVIEW

🙁