I will try to present the problem in a simple way to try to evade the noise of how I try to solve it.I have 2 tables, "Sells report" and "Pays" with the following structure."Sells report"[Report ID][Date][Available cash from yesterday] Virtual column...

The thing is that they are in spanish, but I can share them if it helps.41. "Pays in cash"SUM(SELECT(Pagos[Total],AND([Fecha de pago]=[_THISROW].[Fecha de reporte],[Metodo de pago]="Efectivo")))+SUM(SELECT(Nomina[Nt + SE],AND([Fecha de pago de nomina...

They refer each other in the same table.I need them both to be virtual columns because I have another table called "Pays" so, when someone register a pay (sometimes from a previous day), the virtual column [Pays in cash] updates and this must update ...

For the [Available cash from yesterday] I have tried two ways.1.Make a virtual column named "Most recent report" with the formula MAXROW("Sells report","Date", [Date] < [_THISROW].[Date])Then, in the virtual column [Available cash from yesterday] use...