Forum Discussion
Previous value from one calculated column
AlienSx Thanks for your solutions maybe I am doing someting wrong but there is still Expression.Error: A circular reference was encountered during evaluation. But this works for me :
= List.Transform(List.Skip(List.Accumulate(#"ZmenenĂ½ typ1"[Rate], {1}, (s,c)=> s & {List.Last(s)/c})), Number.From)
but thanks i appreciate it
AlienSx Translation of Source is Zdroj in my language . I thaought that is ok to put there only "Source". I repleace Source with name of table and there is anothr error
Expression.Error: A circular reference was encountered during evaluation.
I completely overlooked that you are trying to create [Def] column with this code đŸ˜‚ It's not going to work. Give me some time. Taking your numbers into consideration overflow comes sooner than later.