Show last date with data

[luirib]

I have a table with daily opening and closing balances. The table only has information for those days where transactions occurred (e.g. no data for weekends). However, when I am building my report, I want to show the opening and closing balance for every single day, including those days with no transactions. In other words, the opening balance for Saturday, Sunday and Monday would be Friday's closing balance.

Is there a way to go back on each line and retrieve the balance of the last day that had information?

 

[Aladin Akyurek]

No ranges specified. Why not?

=LOOKUP(9.99999999999999E+307,E:E)

gives you the last balance value from column E. Adjust to suit.

 

[luirib]

No ranges specified. Why not?

=LOOKUP(9.99999999999999E+307,E:E)

gives you the last balance value from column E. Adjust to suit.

Mine is a PowerPivot (DAX) question, that is why no reference to a range.

The table would have 3 columns: Date, Opening Balance, Closing Balance. Again, non-working days like weekends do not have an opening or closing balance. What I am trying to do is display said dates with the closing balance of he last working day. Thanks.

 

[ImkeF]

This should work for your case as well: https://social.technet.microsoft.co...sing-powerpivot?forum=sqlkjpowerpivotforexcel