Get the last non blank value of a column

[webportal]

This is my table:

For each "No", I want to get the value of column "Data" that is non-blank.

For example, for "No" = 1203210:

That value would be 30/04/2016

And for "No" = 1202547:

The value would be: 31/01/2017.

Thus, the results I'm expecting are supposed to be shown on an additional calculated column:

[webportal]

@amitchandak 

I need a CALCULATED COLUMN.

That expression returns an error when typed into a calculated column: "A circular reference was detected..."

[amitchandak · Accepted solution]

@webportal , Try like

maxx(filter(Table, [No] =earlier([No]) && not(isblank(Table[Class]))),[Date])

[webportal]

That's a lot better!
It also works with an intermediate table 😉

[amitchandak]

@webportal , You can try measures like

Measure =
VAR __id = MAX ('Table'[No] )
VAR __date = CALCULATE ( MAX('Table'[date] ), ALLSELECTED ('Table' ), 'Table'[No] = __id , not(isblank(Table[Class])))
RETURN CALCULATE ( Max ('Table'[date] ), VALUES ('Table'[No] ),'Table'[No] = __id,'Table'[date] = __date, not(isblank(Table[Class])) )