Get the last non blank value of a column with DAX

[webportal]

I want a Column to find the last non blank value from "Class" following the order of the "Date" column.

Thus, the first 3 rows will be empty.

Rows from 31/01/2016 to 30/04/2016 will be A.

And ALL the remaing rows will be B.

I know the following will work:

Coluna =

VAR EstaData = Tabela[Data]

VAR DataMax = CALCULATE(MAX(Tabela[Data]), FILTER(ALL(Tabela), Tabela[Data]<= EstaData && LEN(Tabela[Class])>0))

RETURN

CALCULATE(MAX(Tabela[Class]), FILTER(ALL(Tabela), Tabela[Data] = DataMax))

But... isn't there a better/cleaner way??

Thanks for helping!

[yingyinr · Accepted solution]

Hi @webportal ,

You can create a calculated column as below：

Coluna =
CALCULATE (
    LASTNONBLANK ( 'Tabela'[Class], MAX ( 'Tabela'[Data] ) ),
    ALL ( 'Tabela' )
)

Best Regards

[webportal]

@yingyinrThank you!

[mahoneypat]

Please try this measure expression, replacing T1 with your actual table name.

LNBV = LASTNONBLANKVALUE(T1[Date], MIN(T1[Class]))

Pat