Get last non-empty value between 2 tables

[Anonymous]

Hi,

I have two tables like the ones I show in the image related to ID_DAY.

When I display them in a table, the DAY and IMPORTE fields look something like this:

What I want is that when a day has no value, in this case 04/01/2022, it takes the value of the last previous date that has an amount. In this case it should be:

I have tried different ways and with different formulas but none have worked for me.

Somebody could help me?

Thx

[CNENFRNL · Accepted solution]

Simple enough

For fun only, a showcase of powerful Excel worksheet formulas,

[tamerj1]

Hi @Anonymous 

If only one blank cell at a time, then you can use the new OFFSET function. If in sny case there are multiple consequent blank cells then little more complex dax will be required. Please advise