Forum Discussion

sabd80's avatar
sabd80
Helper IV
1 year ago
Solved

Calculated Column error Circular dependency

Hi, I am trying to create a few calculated columns from one table.   I had no issue creating the first one, Actual: Actual = CALCULATE(sum('Consolidated Sales'[GrossSalesValue]),'Consolidate...
Need Help
  • sabd80's avatar
    sabd80
    1 year ago

    I solve it.

     

    Budget=
     IF('Consolidated Sales'[Source]="Budget", 'Consolidated Sales'[GrossSalesValue])
lbendlin's avatar
lbendlin
Super User
1 year ago

is GrossSalesValue a calculated column?

sabd80's avatar
sabd80
Helper IV
1 year ago

no