Im looking to add a third virtual column that shows me the compounding of the expenses balance each day. Does anyone knows a formula for this?
sample
1 Like
You may wish to try an expression something like below for the VC
SUM(SELECT(Table Name[Daily Expenses],[Begins]<=[_THISROW].[Begins]))
2 Likes
Hi Francisco, how do you resolve this?
Many thanks!!
hello.how can i subtract or sum 2 rows in one colums to write another colum