Column which shows the last non "x" value of the column according to table sorting

[FatherTheWizard]

I have table that contains the columns date and column - and I would like the results in "column_wanted_result".

-> Basically the code should pick the latest non "x" value according to the tables sorting which is done from newest date to oldest

What would be the best way to do this? Preferably in M since I might need to reuse the column.

date	column	column_wanted_result
20220201	x	wanted_value
20220101	wanted_value	wanted_value

[amitchandak · Accepted solution]

@FatherTheWizard , A measure like

lastnonblankvalue(Table[date], max(Table[column]))

or

try a new column

lastnonblankvalue(Table[date], (Table[column]))

[FatherTheWizard]

Yep this should work if I first replace x to null. Thanks.