Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Expression Error: A cyclic reference was encountered during evaluation.-- Seek for help

Hi experts,   I am new to PBI and of course need some help with queries.  When I run the two quries below. I get the error message in the subject line.  When I run the first query or the second que...
Need Help
AnalyticPulse's avatar
AnalyticPulse
Solution Sage
2 years ago

here is an alternative to your code, just replace these line from your code and let me know if it works:

#"Added Conditional Column1" = Table.AddColumn(#"Added Column", "Instructor_FN", each if Text.Length([INST_FIRST_NAME]) = 0 then [FACULTY_FIRST_NAME] else [INST_FIRST_NAME]),

#"Added Conditional Column2" = Table.AddColumn(#"Added Conditional Column1", "Instructor_LN", each if Text.Length([INST_LAST_NAME]) = 0 then [FACULTY_LAST_NAME] else [INST_LAST_NAME])

 

 

Learn Power BI free:

Blog: AnalyticPulse 
Youtube Channel: AnalyticPulse

Power BI : getting started

Dax functions

powerbi Visualisation

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    It worked !!  Thank you so much !!  I've struggled with this issue for a while and was going crazy. ha!

    Would you mind explaining why this was happening?   Just because specifying the table name in two different queries?