How to increment a column from the present day

[Spotto]

hello guys i need a big help.
I have a table that has a calculated column, I needed that when this column gives the result 3, the b.i can count how many days from the day the 3 appeared, how many days the 3 will appear, that is, I needed to increment the current day with the following days .

EXAMPLE:

Today

Next Day...

Next Day...

and later it will add all the days that the column continues with the number 3

tks for help me 🙂

[amitchandak · Accepted solution]

@Spotto , do you have a date column? If so we can do. We need some reference point of data to be added

example

new column =

var _1  = datediff([Date], today(), day)

return

if(_1 <=3, _1, 3)