I want to do something like in the example, h...

[Test_Birimi]

I want to do something like in the example, how can I get the previous value for comparison.

what should be the formula for the previous value?

Thanks

[Test_Birimi]

Can you help me?

[Aleksi_Alkio]

You can write the previos value with the app formula like LOOKUP([_THISROW].[DATE],TableName,“Date”,New Value). Please remember that the value will change every time when you open & save the record even if you didn’t change the “New value”.

[Test_Birimi]

@Aleksi_Alkio @Lynn

Any other suggestions? Please help, I want to write the previous date and value on each line.

[Test_Birimi]

and these values will not change

[Yilmaz_Kandis]

@Test_Birimi You can also try to get previous row value in Google Sheets by using OFFSET function

[Aleksi_Alkio]

The LOOKUP expression will do the job if you use the key column for it. In this sample I assumed that it would be the Date but it’s probably the ID when I checked your table structure again.

[Test_Birimi]

@Aleksi_Alkio I submitted a table structure.

[Lynn]

Hi @Test_Birimi I may have misunderstood your question but If Aleski solution is not doing the job, maybe try adding a VC to get the previous date and then use that to select new value for previous value.

MAX(SELECT(tblName[Date],[Date]=<[_THISROW].[Date]

then for previous Value select(tblName[New Value],[Date]=[VC].[DATE]

[Test_Birimi]

@Lynn

thanks i try now

[Test_Birimi]

@Lynn

select(tblName[New Value],[Date]=[VC].[DATE]

[VC].[DATE]

Error in expression [VC].[DATE]

[Test_Birimi]

I can not do this part, it gives an error

[Test_Birimi]

what is the problem?

[Lynn]

Hi try ANY(SELECT… and put in your column and table names etc.

[Test_Birimi]

ANY(Select(Table[new value],[Date]=[VC Date].[Date]))

[Test_Birimi]

I understood in this way, but unfortunately did not happen