Please Help

[Mirzohid]

1) i couldn't fix my complicated formula which i don't understand either, so I am changing the way of formula and that's gonna be simplier. Can you give me the formula of this logic and i can structure it by using your way. Logic: Virtual column needs to add itself number "10" eachday without losing its previous value. and minus sum of this column [ Expenses] (which contains daily expenses). If today's all expenses value is 5  then show me Today: 5 (bcs 10-5), Tomorrow: 15 (5+10), Aftermorrow: 25 and etc.  Mine is losing its previous value and calculating the formula again. Please reply, you would solve my headache.


2) Btw how i can add number 3 to this column (contains this formula) not to expenses column (i can add expense form another table). If i add this 3 to this formula by doing arithmetic, it will calculate this everday but i need to add this 3 for one beggining time that's it.

[rmsmeltz]

@Mirzohid 

1. Here's a possible formula for your virtual column:

SUM([Previous Value], 10) - SUM(SELECT(Expenses[Daily Expenses], [Date] = TODAY()))

This formula should add 10 to the previous value of the virtual column each day, and then subtract the sum of the daily expenses for that day. Note that this formula assumes that you have a table called "Expenses" with a column called "Daily Expenses" that contains the daily expenses for each day.

1. If you want to add the number 3 to the virtual column for a one-time starting value, you can modify the formula as follows:

IF(TODAY() = DATE("2023-04-05"), 3, [Previous Value] + 10) - SUM(SELECT(Expenses[Daily Expenses], [Date] = TODAY()))

This formula uses an IF statement to check if today's date is equal to the starting date (in this example, April 5th, 2023). If it is, the formula sets the virtual column value to 3. Otherwise, it adds 10 to the previous value of the virtual column.

[Joseph_Seddik]

Virtual columns do not store values, they are calculated columns and their formulas are reevaluated with each sync.

You have to use physical columns to store data.