Forum Discussion

sabd80's avatar
sabd80
Icon for Helper IV rankHelper 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])
sabd80's avatar
sabd80
Icon for Helper IV rankHelper IV
1 year ago

I solve it.

 

Budget=
 IF('Consolidated Sales'[Source]="Budget", 'Consolidated Sales'[GrossSalesValue])