Forum Discussion
Add columns with list of keywords - a cyclic reference was encountered during evaluation
I have two tables:
1) Anamnesis with a long free text column (Diagnosis) for each patient.
2) Conditions of interest(Named ListOfDiagnosis): A table consisting of only those conditions I am interested in.
Having looked at an other solution on this forum I tried the proposed solution on my example
Table.AddColumn(
#"Anamnesis","NewColumn",
each let CurrentText =
[Diagnosis] in Table.SelectRows
(
ListOfDiagnosis, each
Text.Contains(CurrentText, [condition]
)
)
)
However when I execute this code I get: a cyclic reference was encountered during evaluation. I am unable to see this cyclic reference and it is driving me mad(der). 🙂
Hope for some help from the community.
Thanks
Anamnesis
🤔 hmmm, it is working on my side. I created mock Anamnesis and ListOfDiagnosis tables (with teh relevant info and structure, although simpler than yours) and it works fine. I do not get any error. Plus looking at the code I really do not see any circular reference problem.
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
6 Replies
- AlB
Community Champion
Hi Anonymous
Can you show the full M code for the query? I don't really see any cyclic reference in what you've written
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
- AnonymousNot applicable
Thanks for taking time to look into my problem.
But I believe it was the entire code I put in. Please see attached a picture of the code.
NB: The original example listed wrong name for one column. Correct name is in this code [Diagnose].
Thank you so much.
- AlB
Community Champion
That is the code for that step only (or so it looks). I mean the code for the full query. Open the advanced editor to copy the whole thing and paste it here. I just ran a quick test and your for that step throws no error. So the error must be somewhere else
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers