I am creating a new calculated column called Final_Value in my calculated table called INDEX_1.
The condition is I have three columns called Kombi,JJJJ_MM, Value. Each kombi consists one row entry for each month starting from 12-2020, till 06-2024. The logic starts from December 2020. For that month the Final_Value is the same as Value. From the next month, if the value is 50% more than the Previous month’s Final_Value and the difference is greater than 1000,then change the current value to 1.5*Final_Value of last month.