Problem with calculated column

[Anonymous]

I created a calculated colum with the following code:
PRESSA GUESS = LASTNONBLANKVALUE(Merge3[Merge2.cp01.frman], MIN(Merge3[Merge2.cp01.frman]))
Which is not working
I would like to make it return for the same (item - on the right) the earlier value in chronogical terms when it's blank.

Any suggestion?

Expected output is like the present calculated column but with value 31 loaded on it.
Thank you.

[Anonymous · Accepted solution]

Couldn't make it work within that one, solved within this one:

Column =

VAR ThisData = Merge3[Dates]

VAR DataMax = CALCULATE(MAX(Merge3[Dates]), FILTER(ALLEXCEPT(Merge3, Merge3[items.itnbr]), Merge3[Dates]<= ThisData && LEN(Merge3[Merge2.cp01.frman])>0))

RETURN

CALCULATE(MAX(Merge3[Merge2.cp01.frman]), FILTER(ALLEXCEPT(Merge3,Merge3[items.itnbr]), Merge3[Dates] = DataMax))

[amitchandak]

@Anonymous , Try a new column as

var _max= maxx(filter(Merge3, Merge3[items.nbr] =earlier(Merge3[items.nbr])),Merge3[Dates])
return
maxx(filter(Merge3, Merge3[items.nbr] =earlier(Merge3[items.nbr]) && Merge3[Dates]=_max ),Merge3[PRESSA_GUESSA])