Forum Discussion
Get last non-empty value between 2 tables
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
Simple enough
For fun only, a showcase of powerful Excel worksheet formulas,
2 Replies
- tamerj1
Community Champion
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
CNENFRNLSimple enough
For fun only, a showcase of powerful Excel worksheet formulas,
