Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cyclic reference during evaluation

Good Morning,  I have this query but power query  said me that I have an error expression: Cyclic reference during evaluation   Table.AddColumn(#"Aggiunta colonna personalizzata3", "MeseGennaio", ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Actually, I'd write this as:

     

    Table.AddColumn(#"Aggiunta colonna personalizzata3", "MeseGennaio", each if [DWH.GENNAIO] <> null then [DWH.GENNAIO] else if Date.Month(Merged1[Inzio Levori]) <> 1 then null else each Merge1[Ricavo pesato]/((Date.Month([Fine Lavori]) + 1)- Date.Month([Inizio Lavori])))

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cyclical errors occur when a value in a calculation refers to itself, like:

NewTable = Table.Split(NewTable, 2)