Forum Discussion

vstamati's avatar
vstamati
Frequent Visitor
5 years ago

Populate new table field with list last value

I've created a custom function returning a list of values by manipulating several fields from a table. How can I populate a new field into the same table with the list's last value So far it was im...
Need Help
vstamati's avatar
vstamati
Frequent Visitor
5 years ago

Actually I'm already calculating a single value using List.Last( ) and I want that value to populate the new field ( in the same table ) for all records. If I try to invoke the custom function and create the new field I'm getting the following error
"Expression.Error: A cyclic reference was encountered during evaluation."

Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello vstamati 

 

what you mean by create new field...?

Can you share your M-code and some data? When you add a new column to calculate the last item of you list or to use Table.TransformColumns there is no way you create a cyclic reference. Probably the list contains items that create a cyclic reference.

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy