Forum Discussion
Solved
Expression.Error: A cyclic reference was encountered during evaluation.
Hi All, I am getting a very simple error while creating a M code. I tried it on a very simple data set but still its happening in all pbix files... i am posting the pic of the table and the erro...
Hi banav ,
According to your description, you only want to keep the Name and Age columns.
In your query steps, the previous step of Custom1 is "Changed Type", so in the Table.SelectColumns function, you should choose the #"Changed Type" as the table, but not the original "Data_Table", like this:
= Table.SelectColumns(#"Changed Type",{"Name","Age"})Or you can create a blank query, insert the formula:
= Table.SelectColumns(Data_Table,{"Name","Age"})Get the correct result.
About the Applied steps, you can refer to this document: Applied steps - Power Query | Microsoft Docs
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
