Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table.AddColumn with a Expression.Error: A cyclic reference was found during the evaluation.

Hello   I have the following code but I got the Expression.Error: A cyclic reference was found during the evaluation. Thanks in advance for the help = Table.AddColumn(#"Zephyr", "Custom", each if ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Your last line before in has to be following

        #"Lägg till egen" = Table.AddColumn(#"Omdöpta kolumner1", "Custom", each if [a]="" then Text.Replace([#"Deal value#(lf)SEK"],",","") else [#"Deal value#(lf)SEK"])
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Your last line before in has to be following

    #"Lägg till egen" = Table.AddColumn(#"Omdöpta kolumner1", "Custom", each if [a]="" then Text.Replace([#"Deal value#(lf)SEK"],",","") else [#"Deal value#(lf)SEK"])
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Big thanks.

    I got also what I had wrong