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])
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Share the download link of the PBI file.