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 ...
  • 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"])