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])
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, sabd80 

Thanks for lbendlin's reply. You can provide a pbix file without sensitive data for testing. It might solve the problem faster.

Best Regards,
Yang
Community Support Team