Compare lastnonblankvalue with the previous one

[Saud19999]

Hey there,

I have a "date" table and another table "Tank" , I have a measure to get the LASTNONBLANKVALUE, now I need another measure to get the second LASTNONBLANKVALUE.

here is the BI file

Sample v2.pbix

Thank you

[Jihwan_Kim · Accepted solution]

Hi,

Please try something like below.

Before Last day nonblank all clusters - tank =
VAR _lastnonblankdate =
    MAXX (
        FILTER (
            ADDCOLUMNS ( VALUES ( 'Date'[Date] ), "@sumofvaluetank", [SumOfValue_tank] ),
            [@sumofvaluetank] <> BLANK ()
        ),
        'Date'[Date]
    )
VAR _beforelastnonblankdate =
    MAXX (
        FILTER (
            ADDCOLUMNS (
                FILTER ( VALUES ( 'Date'[Date] ), 'Date'[Date] < _lastnonblankdate ),
                "@sumofvaluetank", [SumOfValue_tank]
            ),
            [@sumofvaluetank] <> BLANK ()
        ),
        'Date'[Date]
    )
RETURN
    CALCULATE ( [SumOfValue_tank], 'Date'[Date] = _beforelastnonblankdate )

[Saud19999]

Appreciate your fast response, it worked 👍